when one is selected it goes to the correct record for Machines and displays the proper record.
There is more than one way to do that. What method do you use?
Is the layout based on machines or SerialNo? (What is selected in "Show Records From" in "Layout setup..."?)
For your drop down, it would appear that it should be set up on Machines::UserID and enter the UserID. The first and last names can be displayed for "also use values from" second field and be taken from a calculation field in Clients that combines the values of the two name fields.
Thanks for the response. Works great.
2 additional questions, please. Is there a way to not display the UserID? I would rather just display UserLastName and UserFirstName. How can I display those 2 fields and just get the UserID?
a) Use a pop up menu instead of a drop down list
b) Put the calculation field from Clients that combines first and last names on top of the UserID field. Give it an opaque fill color and use behavior settings to prevent access to this field when in browse mode. This hides the UserID field behind the name field, but clicking on the name field deploys the drop down list--which will disappear back behind the nname field when you exit it.