Limiting a pop-up menu to only show records marked "active"
Posted on 2012-12-21
I have a clients table that contains the ID, name, and a active field (0 for inactive, 1 for active).
I want to have a layout where a user selects the active client and then moves on to another layout passing the ID as a variable.
The problem - I can't figure out how to limit the field to only display active clients.