So a little bit of guess work here, because I can’t see the inner workings of your app.
But, I’m assuming that you have a Quotations sheet/table, and that table includes a column or columns for the model information. And now you want to be able to add multiple “models” per quotation.
The best way to do this would be to separate the model information from the Quotations table. So…
- Create another table, call it something like Quotations-Models
- In that table, have the following columns:
- Quotation ID: this will be a reference to your quotations table
- Other columns as necessary to describe the “model”
In your User Interface, you will need to adjust it so that the user creates the initial quotation without any model information - this gets you a Quotation ID that can be used when adding models. Then you can allow the user to add an unlimited number of “models” to the quotation, one by one. Each will be a single row in the Quotations-Models table, using the same Quotation ID. Then you can link these back to the quotation with a multi-relation using that ID.
In terms of all the calculations, it might make sense to also move those to the Quotations-Models table, and summarise them using rollups through the multi-relation. But again, that’s just a bit of speculation because I don’t know the inner workings of your app. I’m really just describing how I would handle a situation like this.