I've done a pretty good search for the answer to this already and viewed a lot of posts on this same topic, however I still cannot understand well enough to make it work for me, so I'd really appreciate someone who can 'hold my hand' please and assist.
I have a record producer on the incident table that is for building faults, I have a variable that asks what the issue is with and there are a number of options for users to select from.
If they select "Desks" for example the next field that will be required is for them to enter the desk number, which we have a list of on the cmn_location table.
What I'd like to do is to only show desks when desks are selected, or only show rooms if rooms are selected and show all if they choose something else like air conditioning for example.
The variable fields I have are:
| Variable Name | Field type | Option names |
| u_rec_issue | select box | Air Conditioning |
| | | Desks |
| | | Rooms |
| | | Plumbing |
| Variable Name | Field type | Field name | Choices |
| u_rec_location | reference | cnm_location_type | room |
| | Location [cmn_location] | | desk |
Any assistance would be very much welcomed thank you.
