I am relatively new/inexperienced, using Access 2016 with Windows 10.
I created a database with tables in Access. I want to use look up but have not figured out how to make the look up selections be dependent on client id. (multiple values are ok)
I have a "Client Names" table where all the data entry starts and I enter every client's name of company.
I have a "Buyers" table that includes a client ID and client name field. There are 3 to 5 buyers per client.
(same for engineers, QAs, etc)
I have a "Clients" table where I have a select (look-up) field for Client Name, then for buyers. (and later on for engineers, for QAs, etc.)
Problem: when I select the client name and move on to select the buyers' names, I have to scroll through ALL the buyers that are entered; I had wanted to only scroll through the buyers that had been previously entered for that client name instead of having to scroll through all of the buyers for every client to select buyers for one client.
Is there a way to do that? What is it called...so I may discuss it with a slight bit more ease/intelligence next time?
Thanks,
Synthia