Problems with a one to many form

  • Thread starter oliaccount via AccessMonster.com
  • Start date
O

oliaccount via AccessMonster.com

This is going to sound stupid, but anyway. I have a main form with two sub
forms. One of them works perfectly as a one to many sub form, but the other
is actually sourced from the main table. I'm trying to redesign the system so
that this form actually links off another table, and I can't simply start
over because there is already data in the required fields. I've set up the
second form in an idenical manner to the first, but no matter what I do, the
form simply will not display in a one to many fashion. At best it displays
everything in the table, regardless of which main record I choose.
 
A

Arvin Meyer [MVP]

A one to many relationship uses the Primary Key of the One side table to
connect to a Foreign Key in the many side table. In an Access form/subform,
select the subform in design view and make sure that the matching key is in
the Link Master Link Child property on the Data tab of the property sheet.
If not, add it manually.

BTW, you can always build a form or report over, even with data in the
underlying tables.
 
O

oliaccount via AccessMonster.com

Arvin said:
A one to many relationship uses the Primary Key of the One side table to
connect to a Foreign Key in the many side table. In an Access form/subform,
select the subform in design view and make sure that the matching key is in
the Link Master Link Child property on the Data tab of the property sheet.
If not, add it manually.
Click to expand...

Thanks, that solved it. I knew it would be something simple.
 
Top