I have a form with a field for "Client" (first) and a subsequent field for "Facility" - users select from choices that are from a table that has a Clients field in one column and the related Facility field for each client in another column.
I have got to learn to restrict the viewed choices on the form for "Facilty" for only the facilities that are facilities of the chosen "Client".
I also have to allow users to add - if needed - to both or either of them, and it automatically updates the tables with the add.
Some clients have only one facility, some have many.
Searching for days, tons of books, webpages, and videos, and more confused now than when I started.
Any help appreciated!
Synthia
I have got to learn to restrict the viewed choices on the form for "Facilty" for only the facilities that are facilities of the chosen "Client".
I also have to allow users to add - if needed - to both or either of them, and it automatically updates the tables with the add.
Some clients have only one facility, some have many.
Searching for days, tons of books, webpages, and videos, and more confused now than when I started.
Any help appreciated!
Synthia