Hi fellow AppSheeters!
I am struggling, and have been looking / trying various codes for a solid two hours and getting nowhere…
What I am trying to do is have:
- A list of clients, with their name as label and a site reference (done)
- An entry of an incident, with a site to be chosen (done) subsequently filtering an EnumList of clients by the site (where I am failing)
As far as I can see, this should work when placed in the ‘Valid If’ section:
[_THISROW].[Service Area] = [ServiceArea])
But, when I do that, the field disappears from the form to complete. If I just leave it as ‘Clients[ClientID]’ then all clients are returned, but we have 1,500 across 30 sites so that’s obviously not ideal!
I’m sure there’s something small that I’m missing, so would be very grateful for any help.