I have two tables in a 1:M relationship- the parent has 5 fields in the
primary key and the child 6 (these are actually pretty far downstream in
a complicated ER model, but the problem is between these two). I set up
the relationship with no problem- referential integrity and left outer
join. I have created two forms- one for the parent and one for the
child table. I want to import the child table's form as a subform on
the parent table's form. Using the Subform Wizard, everything goes well
until it gets to the point where I need to specify the linking fields.
It shows a number of entries for these, all of which are single, key fields.
My problem is that Access allows only up to 3 fields for linking a
subform to a parent form, and that would force my having to enter
manually the other 2 fields in the primary key from the parent into the
child. Is there any way of getting around this? Thanks!