mapping table when using a subform

[Rich25]

Hi,

I have a simple database that has 3 tables.

Person
------
PersonId
Name

Mapping
-------
PersonId
OrganizationId

Organization
------------
OrganizationId
Organization

Theres a 1 to many relationship between person and Mapping, and between Organization and Mapping


I have a main form with Person information, then a subform with organization information. The problem I'm having is that no matter what I do, the mapping table does not get populated? Any Ideas or any examples that I could take a look at??

Thanks,
Rich

 

[KenReay]

Hi Rich

Have you set the master \ Child settings of the sub form control?

Presumably your main form is based on a query which joins Person and Mapping?

If so the column OrganizationId, is available inteh main form, make a control and bind it to OrganizationId, make the control visible = false if you do not want user to see it.

In the sub form, ensure the OrganizationId is present (but visible = false if you do not want user to see it)

Now set the Master\Child id of the subform control to OrganizationId.

This should cause your sub form to populate Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK