Would like to develop a quotation system to allow multiple quote items. What is your recommendation on the database/system design.
Similar to the sample app - Quote Generator however this is only one quote item per quotation but we would like to have multiple quote item per quotation.
one of the idea is to have
- multiple columns field for each quote item but this we will be limited by number of quote item per quotation. (based on the max column field we created)
any other idea / suggestion do we have to cater for this requirement?