Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Thanks for your suggestion. The entire database is to allow comparison of multiple quotations from suppliers for the components we require. The Products table lists the products we require, with the names and our detailed specifications. Each is unique, and it is usually our own specification - sometimes our own design. The Suppliers table lists the suppliers who have quoted: most quote on only one product, but some quote on multiple - enough to make entering the data multiple times not particularly smart. The ProductsSuppliers lists the quotations - what product is being quoted on (from the Product table), who is quoting (from the Suppliers table), then the details of the quotation, such as minimum order quantities, pricing, the supplier's specification for the product, and a record of the clarification conversations with the supplier, and finally a judgement of whether the quotation conforms to our requirements. It seems to me if we structured the database the way you suggest, it implies that the products are the ones offered by the supplier - not the ones we want.

Thanks for your suggestion. The entire database is to allow comparison of multiple quotations from suppliers for the components we require. The Products table lists the products we require, with the names and our detailed specifications. Each is unique, and it is usually our own specification - sometimes our own design. The Suppliers table lists the suppliers who have quoted: most quote on only one product, but some quote on multiple - enough to make entering the data multiple times not particularly smart. The ProductsSuppliers lists the quotations - what product is being quoted on (from the Product table), who is quoting (from the Suppliers table), then the details of the quotation, such as minimum order quantities, pricing, the supplier's specification for the product, and a record of the clarification conversations with the supplier, and finally a judgement of whether the quotation conforms to our requirements. It seems to me if we structured the database the way you suggest, it implies that the products are the ones offered by the supplier - not the ones we want.want. A screenshot of the ProductSuppliers form is at http://www.earthcaretech.com.au/images/Screenshot.png