W
WCDoan
I have a form with linked subforms that I created thru the wizard. It uses 3
tables:
Table 1 - Owners - PK = OwnerID
Table 2 - Animals - PK = AnimalID linked to Owners Table by
OwnerID_AnimalTable
Table 3 - FeesTable - PK = FeeID linked to AnimalTable by AnimalID_FeeTable
I was able to add 1 owner, 1 animal, and some fees for the first owner, but
when I add a second owner, then enter animal info, when I go to the fees
table I get an error message stating " you cannot add or change a record
because a related records is required in table tblOwners." I have a field
that displays the OwnersID on the subform and it's the correct one. I don't
understand what's happening. Could someone shed some light?
Thanks,
RandyM
tables:
Table 1 - Owners - PK = OwnerID
Table 2 - Animals - PK = AnimalID linked to Owners Table by
OwnerID_AnimalTable
Table 3 - FeesTable - PK = FeeID linked to AnimalTable by AnimalID_FeeTable
I was able to add 1 owner, 1 animal, and some fees for the first owner, but
when I add a second owner, then enter animal info, when I go to the fees
table I get an error message stating " you cannot add or change a record
because a related records is required in table tblOwners." I have a field
that displays the OwnersID on the subform and it's the correct one. I don't
understand what's happening. Could someone shed some light?
Thanks,
RandyM