Creating a value list
I have a table with user info. One field is labelled "Assigned" and has a value of "Yes" or "No." Another field has the users' first names.
In a layout I want a field that contains radio buttons with only the first names of those in the user table that have a "Yes" in the assigned field. If there's a new user with a "Yes" in the assigned field, then their name will automatically be added to the list.
Any help appreciated.