AnsweredAssumed Answered

Inventory drop-down list based on the validity of two fields in separate tables

Question asked by ChadBarnard on Sep 22, 2014
Latest reply on Nov 19, 2014 by philmodjunk

Title

Inventory drop-down list based on the validity of two fields in separate tables

Post

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.

Outcomes