I am a bit confused about my app’s behavior.
I have 4 tables:
The expected outcome is that, when creating a new Booking, the [Rate] dropdown will only have the [Client Rates] for the client that owns the selected [Client Site]
[Rate] from Bookings table has the following ValidIf condition:
SELECT(Client Rates[ID],[_THISROW].[Client Site].[Client]=[Client])
What actually happens is that when I select the dropdown, the list is empty.
I click New on the dropdown to add a rate but then I click Cancel.
Selecting the [Rate] again, the dropdown will have the correct values.
EXTRA: If, after selecting the Rate, I change the Client Site and then save, it allows me to do it even if the rate should be invalid.
Tried to upload a screen recording but the format is not allowed.