I had line items with parts & labor. Then they can be sorted and summarized as need. They can be filtered in portals, too. But all the records were in one table.
-- sent from myPhone --
I have large quote solution that evolved as additional needed layers were identified by management as being needed to appropriately price the quote with options. I would recommend that you do an entity-relationship diagram (ERD) prior to doing any development and setting up data tables! I now need to redo the quote module because I missed a layer and the structure got way too complex. Because I missed the one needed table/layer/entity, there are way too many calculation fields that are slowing everything down as more and more data is added.
John Mark Osborne's FTS class goes over ERD's. I would highly recommend it! I wish I had taken it years ago!
The Udemy course "Learning FileMaker - Practical Techniques" is by John Mark Osborne and also discusses ERDs and may be a help to you sooner, and at a lower cost.
Thank you both for the answers.
As advised I take first the Udemy course. At the beginning I made an ERD. But it seems to be wrong and I have to update it.
Thanks a lot!