PRODUCT multi-format with different price

[bolognesiedalla]

Hi everyone I am creating an APP to make fertilization plans. The products used in the plan can have multiple formats, and each format has a different price. For example:

MAGIC CROP

tank 1 kg > 11.90 €/kg
tank 10 kg > 10.90 €/kg
tank 1000 kg > 9.90 €/kg

The plan will automatically calculate the most convenient product based on the quantity needed.
How should I organize my tables on google sheet? do I have to provide a FORMAT [PRODUCT] child of PRODUCT table?

this is my PRODUCT TABLEt, where I had organized the [FORMAT] column as an enumlist, but I think it is not the most convenient way

[Joseph_Seddik]

---

@bolognesiedalla wrote:

do I have to provide a FORMAT [PRODUCT] child of PRODUCT table?

Yes, this is what I'd do. 

1. A Products table, with columns presenting intrinsic information about the product.
2. A Formats table, with a Ref to Products table, and here you put a Price column. 
3. In an orderDetails table, should then contain a Ref column to Products and another towards Formats.