chefportal

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

Outcomes