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