Correct Table Structure??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smboyd - 15 Jul 2005 15:43 GMT

I have a database that I use to store job information. The different type of
jobs consist of plan/spec, sheetmetal, design/build. The plan/spec jobs are
bid to only one "owner". The sheetmetal and design/build jobs may be bid to
several "customers". I want to make sure the owners are entered separately
than customers on forms, so I am thinking it may be better to have 2 talbes -
Owners and Customers even though it is possible that the 2 tables may consist
of a few duplicates. Would this be correct?

Reply to this Message

Roger Carlson - 15 Jul 2005 16:30 GMT

Probably you need more than two tables. It's difficult to say with the
information you've given. I'd suggest you do some studying on database
design. It's really the most important part of your database project.

On my website (www.rogersaccesslibrary.com) are some database design
tutorials that might help.

Signature

--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> I have a database that I use to store job information. The different type of
> jobs consist of plan/spec, sheetmetal, design/build. The plan/spec jobs are
[quoted text clipped - 3 lines]
> Owners and Customers even though it is possible that the 2 tables may consist
> of a few duplicates. Would this be correct?

Reply to this Message