Question Building My Companyy Database issues HELP

[Allan_Smith]

Hey guys,

im probably posting in the wrong thread, please forgive me if so -im new to all this

I needed a company database for my Upholstery firm, I needed a database to store all customers data, And be able to produce quotes, invoices etc etc

I ha a quick look online but couldn't find any I could use so attempted to make my own :banghead:



heres my problem:



I have made a customers table so that every time I entered a new customers details on a form, it stores the data in the customers table.

I then made a quotations form where I scrolled through the records until it pulled up the relevant customers details.

and here is where the problem lies...

I then want access to take the details from the boxes containing the customers info and also the details from the quotation and store it in a table so that I then have a table called quotations with all customers details and the quotation details so that I can print the reports (quotes).

I'm at a loss as how to tie the whole thing together and make it work as intended

 

[Minty]

You don't make another table to store the data you have already stored.

I'm guessing/hoping that each Quotation has a unique ID number and that each Customer has a unique ID number. (for the sake of clarity we'll call them QuoteID and CustomerID)

Is each quote unique to one customer but each customer could have more that one quote?

If the above is true then simply store the CustomerID as an extra field in the Quote. You can them pull the customer record in with any Quotes that have that CustomerID in it.