Table setup

10 pts.
Tags:
Microsoft Access
Microsoft Access spreadsheet
I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date - Quote # - Customer - Cust Quote # - Part # - Part Name - Quote Due Date - Qty - Lead Time - Price - Unit The forms we use for quoting include: Buyer Cust Quote # Customer Date Quoted Lead Time Part # Part Name Price Qty Quote # Quote Date Quote Due Date As you can see we don't have the info for Buyer in our current spreadsheet. The second spreadsheet is for jobs. It contains the following information: JOBS Job # - Qty - Quote # - Customer - PO# - Part # - Part Name - Est Hours - Start Date - Due Date - Price The forms we use for Job Write ups include: Customer Due Date Est Hours Invoice # Job # Part # Part Name PO# Price Rev Special Instructions Started I was thinking we would have three tables- Quotes, Jobs & Invoices. I would use the Quote # as the primary Key in the Quote Table and the Job # for the primary key in Job table. My question is since a lot of the information for quotes and jobs are shared - how should I set up the tables. For instance the Customer, Part #, Part Name is actually shared information. Would I put the majority of the information in the Quote Table and share it with the Job Table. Sometimes we don't create a quote when we receive a job. How would you set up your tables? I am using Access.

Software/Hardware used:
Access
ASKED: November 16, 2012  11:39 PM
UPDATED: November 19, 2012  1:41 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

A short answer is that there should be a separate table for the Customer information and then the other tables will reference it.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following