Correct Table Structure??

[smboyd]

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?

 

[Roger Carlson]

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.

--
--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