This should be easy, but has me totally confused. I am trying to save a record in frmLabNotes, but it won't allow the save because a related record was not found in tblCane. tblLabNotes and tblCane have a 1 to many relationship between the field SampleID and referential integrity is enforced. tblCane is the 1 side of the relationship.
What is confusing is that when I look in tblCane there is a record with the SampleID that is used in frmLabNotes. Why won't it save the record from frmLabNotes in tblLabNotes when there already is a SampleID in tblCane?
Thanks.
What is confusing is that when I look in tblCane there is a record with the SampleID that is used in frmLabNotes. Why won't it save the record from frmLabNotes in tblLabNotes when there already is a SampleID in tblCane?
Thanks.