Hello,
I have a table with the following fields NAME1, NAME2, NAME3. The names comes from another table with a list of names so I have a drop down list with all the names for each field. I use certain parameters to reduce the names from the main list.
What I need is that when I choose (assign) a name for the field NAME1, that choosen name does not appears in the drop down list for the fields NAME2 or NAME3.
I imagine a subquery can be the solution, but I have no idea how to set it
I would appreciate your help!
Regards
Tom