Setting up Relationships

[petepope]

I have been using access for sometime but never had the need to setup a
relationship before and I appear not to be getting it right.

I have a Pocket PC with Access on it and I need to design a special
database. I am a Police Officer and I would like to design a Field
Interrogation Database. I think this would use a 1 to many relationship.

I would need a table to contain the information on people that I meet or
Interview or have contacts with. This table would contain their personal
information, name, address, heaight, weight, tattoos, marks,etc.

Then I would need an incidnet table. Date, location and nature of
contact,location, etc.

I want to be able to enter a subject one time, but be able to associate them
with multiple incidents, such as interviewing or having contact with them on
different dates,locations and reasons.

How would I build the 1 to many realationship so that I would only have to
enter a persons information once, but have many incidents tied to thier
record.

Thanks in advance for your assistance.

 

[David Saywell]

Hi Pete,

The table you use to store peoples details (tblContacts) would contain a
field ContactId that uniquely identifies each contact. This field would be
linked to tblIncident. Therefore for each incident you enter the ContactId
only.

tblContact
ContactId (one)
Name
Tattoos
etc.

tblIncident
ContactId (many)
Date
Location
etc.

Hope this helps,

David