M
MikeR
I have a parent table and two different child tables in a
one to many relationship with the parent table. Let's say
the parent is A, with child tables B and C.
In a query that joins A & B with an simple INNER JOIN, if
I add a record to the A table, the B table also adds a
record. Both the PK autoincrement and FK fields from B
(connecting the to PK in A) are in the query.
WHen I do the exact same thing with table C: simple INNER
JOIN with A including the PK autoincrement for C and the
FK field from C in the query, I don't get the same
results. The C table does not add a record. Moreover, a
new record is added to the B table, which is not in the
query.
Similar relationships are defined between the A and B, and
A and C tables.
This seems elementary, but I can't seem to see what is
different. What am I not seeing?
MikeR
one to many relationship with the parent table. Let's say
the parent is A, with child tables B and C.
In a query that joins A & B with an simple INNER JOIN, if
I add a record to the A table, the B table also adds a
record. Both the PK autoincrement and FK fields from B
(connecting the to PK in A) are in the query.
WHen I do the exact same thing with table C: simple INNER
JOIN with A including the PK autoincrement for C and the
FK field from C in the query, I don't get the same
results. The C table does not add a record. Moreover, a
new record is added to the B table, which is not in the
query.
Similar relationships are defined between the A and B, and
A and C tables.
This seems elementary, but I can't seem to see what is
different. What am I not seeing?
MikeR