Hi. I’ve a form in which on of the field takes Ref from another table as a list and displays them as a drop down for the user to select. I’ve added the following formula in ‘Valid_if’ so that the drop down contains only ‘Available’ devices.
This is working fine for a new entry. However, when trying to edit an existing record, this field prompts as invalid as the status is changed to “Sold” during the initial entry. Can you please help me with this?