One form many tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database for our subcontractors. I need the basic
information such as address and telephone number in the database. I also
must have the following information: insurance coverages, signed agreements,
etc. Must I put all those fields in one table? I would like to have one
form to enter the data.

I've started and restarted this database many times. I already have the
basic address information which I've imported from Excel.

Any help will be greatly appreciated!
 
Teri,
That depends on the data...
The Subcontractor is the ONE in a ONE to MANY relationship. Each
contractor should be assigned a unique key value to differentiate that
contractor from all others. (like a ContactorIDNo) A Contactor probably
only has ONE CompanyName, or ONE Address, or ONE City... so those would be
in your ONE table (tblContracors)
If subcontractors have more than 1 insurance policy that you'll have to
keep track of, then that information should be kept in a seperate table
(like tblInsurance) linked to each contractor by an associated
ContactorIDNo. (ex... Contractor 192 has 3 insurance policies listed in the
Insurance table with his ID of 192 associated with those 3 record)
I would bet Signed Agreements would be the same... ONE Contactor MANY
Agreements.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top