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.