Table Relationship issue.

Question
Subject: Relationships - I am issing something 11/18/2008 5:01 PM PST

By: dwilliamson In: microsoft.public.access.tablesdbdesign


Have a database with two tables - tblSite and tblInsp. tblSiteID is PK and
tblInspID, tblSiteID is combo key in tblInsp table. This databse is used to
track inspection for a given site. So, I need to be able to open the frmSite
enter site info, click on the Inspections command button and enter
inspections. I have a third table used to join the the tblSite and tblInsp.
the tblSite to the join table is one - to - many. The tblInsp to the join
table is intermediate. The problem I am having is when i enter an inspection,
exit the inspection form, and then return the inspection I just entered is no
longer linked to the site.


Thanks.