Narrowing down field contents in table

[Melrose]

Hi!

I'm new to Access, and I'm trying to figure out how to narrow down information in a table. For example, I have a "Company" (Column A) field that allows you to select a list of companies. Is it possible in the next field "Employees" (Column B) to show all the employees in that particular company, and not just an entire list of employees from all the companies?

Not sure if this will help but let's say in the Company column, I can select from Nike, Adidas and Under Armor. If I select Nike, would it be possible to see a drop down list of just Nike employees in the "Employees" field (Column B)?



If that is possible, can you help me create that function in my table? Or if you have another suggestion that will help me narrow down my data in a similar fashion, I'd love to know!

Thank you!

[orange]

google cascading comboboxes msaccess