Question about linking data?

[sande2418]

I need to create a form that prompts for a vendor ID... then I need it to return a drop down list of projects tied to the specific vendor ID that was entered.... once the project is selected via the drop down ...I need it to return a list of orders tied to that project. I have a sub form that returns the data for the order selected.... Key info: Access 2016.... 1 vendor can be assigned to multiple projects...project can only be assigned to 1 vendor....Project can have multiple orders but orders can only be assigned to one project. Open to any ideas & suggestions on how best to do this Thanks in advance!

[pbaldy]

Might this be an option?

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