Problems with a one to many form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

oliaccount - 02 Jul 2007 11:13 GMT

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.

Reply to this Message

Arvin Meyer [MVP] - 02 Jul 2007 11:40 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.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
[quoted text clipped - 7 lines]
> 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.

Reply to this Message

oliaccount - 02 Jul 2007 11:52 GMT

>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.

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

Reply to this Message