New Database on Customer Quotes

[rkalapura]

Hai,

I am assigned to create a customer quote database for our company. Now it is in excel and already have 40,000 records and increasing average 25 records everyday. The way they want to send quotes are:

- The number of items in the quote are varied from 1 o 15.
- Each item has six different prices, depends on the order qty and want to mention in different adjusent lines.
- Each item has different delivery time depend on order qty.
- Company's sales Terms and conditions need to be printed at the end of each quote in separate page. (two full pages)

How do I create the table to accommodate all these fields? Is it possible to accommodate all items/sub items in one table under one qutoe id. I have customer table, product table etc ready and little confused to create the Quote table. Any ideas, thoughts or reference on this type of database is really appreciated.

Thanks in advance for help and best regards

[Megood]

I would make a quotes table with a lookup field to a Products table and include a Qty field. Use the Client as the main for and Quotes in the subform. You would be able to add as many products to that quotes as you wish. Link them by customer number.

You could either have price of product and multiply by Qty but if this price can't be calculated for some reason you could set up multiple products with different Qty.

A calculated field would work for the delivery date as long as you have a set formula. Might take a bit of tinkering to work out.

As for the terms and conditions, I suggest using a footer on that report.

I hope this helps.

[orange]

Do some reading on database design, normalization and entity relationship diagramming.

see post#4 here for more https://www.accessforums.net/access/...ing-26467.html