Inventory drop-down list based on the validity of two fields in separate tables
Maybe I'm going about this the wrong way, but what I'm trying to do is create a drop-down list that only has values whose records have two matching values from different tables.
On the Orders table, I have a field that designates what "Image" a project is going to be. I have a portal on the Orders table that pulls information from a standard type of "Order Line Item" table. When a person selects which Vendor provides the material on the portal, I want the next field to be a drop-down list that shows only products from that Vendor and that match the specified "Image".
I have image fields on the Product table as well as the Orders table.
Do I need to create a separate table that pulls the information into the same table and then reference that table?
Thanks for any help.