W
WCDoan
I have 3 tables
Table 1 PK = OwnerID
Table 2 PK = AnimalID FK to Table 1 = OwnerID-AnimalTable
Table 3 PK = FeeID FK to Table 2 = AnimalID-FeeTable
I chose all the fields from these 3 tables in the first screen. On the next
screen I select Table 1 as the one to view data by. If I select the "form
with subforms" option, everything is fine. However, when I chose the "linked
forms" option, the OwnerID from Table 1 doesn't appear in Table 2 which
causes an error when Access tries to write the record in Table 2 when I move
to Table 3. I thought if you used the wizard, it was suppose to handle all
the parent/child relationships. Any ideas as to why this works with the
subforms and not with the linked forms, or is there something I'm suppose to
do to make this work? Just when you think you're on the right path, you find
yourself totally lost.
Help please,
RandyM
Table 1 PK = OwnerID
Table 2 PK = AnimalID FK to Table 1 = OwnerID-AnimalTable
Table 3 PK = FeeID FK to Table 2 = AnimalID-FeeTable
I chose all the fields from these 3 tables in the first screen. On the next
screen I select Table 1 as the one to view data by. If I select the "form
with subforms" option, everything is fine. However, when I chose the "linked
forms" option, the OwnerID from Table 1 doesn't appear in Table 2 which
causes an error when Access tries to write the record in Table 2 when I move
to Table 3. I thought if you used the wizard, it was suppose to handle all
the parent/child relationships. Any ideas as to why this works with the
subforms and not with the linked forms, or is there something I'm suppose to
do to make this work? Just when you think you're on the right path, you find
yourself totally lost.
Help please,
RandyM