Look Up - show fewer options by matching criteria....?

[synses]

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

[pbaldy]

Sounds like cascading combos:

Baldy-Cascading Combos

[synses]

Yes, thank you, that is EXACTLY what I am talking about. How wonderful that you attached a sample, because, based on my inability to decipher your response, I think I need to change my label from "Novice" to "Moron" and without the examples I would not have understood! You are generous to share and I appreciate that.

Would you be so generous as to walk me through how to enter that programming info to accomplish that? I have never entered any programming in ACCESS, and have only limited experience doing it in EXCEL, so I would need to be walked through in plain language, probably way to much to ask, I realize.

There's no way to do that with the look up feature in ACCESS, right?

Even if you don't walk me through doing it, I appreciate at least knowing the name of what I am trying to do, cascading combos!
Gratefully,
Synthia

[pbaldy]

Here's a primer on how/where to enter VBA code:

http://www.baldyweb.com/FirstVBA.htm

The "requery" method could be done with a macro instead of code, should you prefer it.