Hello.
On my Database, I have a Tables called Quotation, Quotationlab and Quotationmat.
On the Quotationmat, I have the following fields, Title, Quotation_No, QUantity, Unit_Price, Additional_Cost and Description.
I want to make a new table that will hold a list of builders materials such as bricks, windows and doors. WHen I go to my Quotationmat and select add new from my project, I want to be able to pick from a drop down box from the new table and select an item in the title box and have it put all the other information into the relavent boxes, so,
Say I click on Title on my add page and select a door. In my new table it will hold all the information on a door, such as Unit_Price and description, so When I click on Door, it will put the Unit_Price and the description for that door from the new table into my quotationmat add page?
Cheers
Paul.