chefportal

Conditional value list

Discussion created by chefportal on Sep 19, 2013
Latest reply on Sep 19, 2013 by LyndsayHowarth

Hi All,

 

I have a database that has Ingredients and Suppliers, each ingredient can have more than one supplier and have a preferred supplier.

 

My problem is this: I have a fields "Preferred Supplier","Product Type" in the ingredients table and have "Supplier Name" and a related table with "Product Type" for suppliers

 

Eg: Supplier A sells Seafood and Meat, so the layout has the suppliers name with a portal with product type.

 

In the ingredients layout I would like a conditional value list for "Preferred Supplier" based on Seafood being picked from "Product Type" list with Seafood in their related table to show up.

 

I can make a conditional value list, but not sure how to link the Supplier with related table to value list in Ingredients layout.

 

any help would be appreciated

 

Mark

Outcomes