AnsweredAssumed Answered

Conditional value lists-- is there another way?

Question asked by petropix on Oct 29, 2013
Latest reply on Oct 30, 2013 by petropix

Hello again--


I have a Product table (FM-PROStarter Solution: INVOICES) that includes at least 4 Product Catogories, about a dozen Brands, and each Brand has several varieties/models, attributes etc. I need to create a GUI list of the Catagory/Brand Names and beside each name a drop-down field showing the MODEL list relating to the Brand. Do I need to make seperate tables for each Brand/Catagory-- or can I fish the relevant data out of the Main Product table? Also, once the Model/Item is selected in the drop-down, an adjacent Button must trigger/enter the selection into a Line Item on the invoice (adjacent portal).


Any help in structuring this would be greatly appreciated.