Optimal ERD / Design

Discussion created by chefportal on Aug 16, 2013
Latest reply on Aug 26, 2013 by chefportal

Hi All


I am still very new to FileMaker and am stumped for an optimal ERD / Design for a product that can have many variances but is still the same product and stocked by many suppliers.


Eg: Yellow Widget ( Made By Widget Co ) can be purchased 1 x 50g or box of 10 x 50g or 100 x 50g all with their own UPC Number, Also the preferred order qty and supplier can be set.


When you place an order a dropdown list shows with preferred order on top with the other options below.


Eg: I usually order 10 x 50g so the list will show ( 10 x 50g first then 1 x 50g then 100 x 50g)


Any advice would be appreciated