O
oldblindpew
Table1 is the parent table, Table2 is the child table. Table3 is joined to
Table2 in a one-to-one relation. The purpose of Table3 is for additional
fields that only apply to a subset of the records in Table2.
A form/subform is used to view Table1 header info with Table2 detail info.
I think I want a similar form/subform to view Table1/Table3.
Q: Does this mean the same key field used to relate Tables 1 & 2 must also
be present in Table3, making Table3 another child to Table1?
It seems this must be so; on the other hand it might be unnecessary in view
of the one-to-one relationship. The records in 3 are like extensions of the
records in 2, and could appear to somehow inherit the relationship back to
the parent table.
Thanks,
OldBlindPew
Table2 in a one-to-one relation. The purpose of Table3 is for additional
fields that only apply to a subset of the records in Table2.
A form/subform is used to view Table1 header info with Table2 detail info.
I think I want a similar form/subform to view Table1/Table3.
Q: Does this mean the same key field used to relate Tables 1 & 2 must also
be present in Table3, making Table3 another child to Table1?
It seems this must be so; on the other hand it might be unnecessary in view
of the one-to-one relationship. The records in 3 are like extensions of the
records in 2, and could appear to somehow inherit the relationship back to
the parent table.
Thanks,
OldBlindPew