I currently have table set up of all the items currently used by the company. e.g. A-F
Process 1 uses a/b/c/f
Process 2 uses a/d/e
etc etc
Each job/process is also given a quote number + contact details etc.
What I require but cant seem to get my head round a simple and efficient way to do this is somehow to relate Quote to a Process and then have a form that will let you fill in boxes from the quantity of a/b/c/f required and will spit a final price out at the end.
Current best idea is
tblQuoteinfo (with quote numbr and contact details etc etc)
tblQuantity (linked to tblQuoteinfo via Quote Number, with column headings being the names of items from price list, so in the rows you have quote number then the quantity required of each item e.g.
Quote Number || Item 1 || Item 2 || Item 3 ||
---------------------------------------------
---Q1232-----||---3----||---1---||---5---||
with different tables for different proceses
tblPriceList (with columns of ID/Item description/price)
but i cant get this to work and i know its a very bad way
*Note* I need to store multiple quotes so one table with price and quantity wont work?
Process 1 uses a/b/c/f
Process 2 uses a/d/e
etc etc
Each job/process is also given a quote number + contact details etc.
What I require but cant seem to get my head round a simple and efficient way to do this is somehow to relate Quote to a Process and then have a form that will let you fill in boxes from the quantity of a/b/c/f required and will spit a final price out at the end.
Current best idea is
tblQuoteinfo (with quote numbr and contact details etc etc)
tblQuantity (linked to tblQuoteinfo via Quote Number, with column headings being the names of items from price list, so in the rows you have quote number then the quantity required of each item e.g.
Quote Number || Item 1 || Item 2 || Item 3 ||
---------------------------------------------
---Q1232-----||---3----||---1---||---5---||
with different tables for different proceses
tblPriceList (with columns of ID/Item description/price)
but i cant get this to work and i know its a very bad way
*Note* I need to store multiple quotes so one table with price and quantity wont work?
