I’m here to help
- Local time
- Yesterday, 17:22
- Oct 29, 2018
Hi. Thanks for the additional info. Can you please post the SQL statement of your query too? The dropdown alone would/should not autopopulate those other columns for you.
I won't be using the lookup feature - as we've discussed.
However I was experimenting and did establish a lookup.
Then I happened to notice when I created this query - and was in datasheet mode the system would auto populate the FirstName and LastName fields, when I select the CustomerID