Joining mutiple tables

[millrat]

Hi,

I am building a database to record incidents in the workplace. I have a main table which records the details of an incident, time place type etc. My other tables record information on each type of incident, injury, loss, fire etc. Since all incidents have details I use this as the main table but since the incidents are of varying types the other tables will not have as many records. The details table will have the pkey assigned and the other tables should record the assigned pkey. What type of join should be used in this example? How will the pkey be recorded by the other tables? I am thinking a one to one on the pkey with ref integrity enforced and updates/deletes checked. Would I then be able parent/child the other tables in a subform? I have tried this approach but I am getting duplicate records somehow...
Any suggestions appreciated.
millrat

 

[lespaul]

check out Understanding SQL Joins

Leslie

Come join me at New Mexico Linux Fest!

 

[PHV]

Another useful source of info for your issue:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886