Linking 3 Tables

[jackie]

I have three tables customer personal details, complaint details, enquiry
details. Complaint details and enquiries have to have seperate unique ids as
the complaints has to follow certain government regulations which is why they
are in seperate tables. What i am trying to do is on the main form Customer
details is have the option of wheither a customer is raising a complaint or
an enquiry. When i use the form wizard i can get the main form to link
directly to one of the other tables but not both. When i choose both child
tables i get a blank form. If i choose the parent and one child then things
are ok. Why cant i get both? if this is not possible is there another way of
having the option?
thanks help would be appreciated

 

[tina]

presumably tblCustomerDetails is the parent table in a parent/child
relationship with each of the other two tables. you can create a
mainform/subform setup, with TWO subforms - one for each of the child
tables. just do it manually:

make sure tblCustomerDetails is linked to each of the other two tables *in
the Relationships window*. create a form bound to tblCustomerDetails
(frmCustomerDetails). create another form bound to tblComplaintDetails
(sfrmComplaintDetails). create a third form bound to tblEnquiryDetails
(sfrmEnquiryDetails).

open frmCustomerDetails in design view. add a subform control from the
Toolbox toolbar. with the subform control selected, open the Properties box
and set the SourceObject property to sfrmComplaintDetails. if you set up the
table relationships correctly in the Relationships window, Access should
populate the LinkChildFields and LinkMasterFields properties automatically.
if it doesn't, click in the LinkChildFields property, then click on the
Build button (...) at the right side and choose the linking fields in the
dialog box. add another subform control and set the SourceObject property to
sfrmEnquiryDetails; set the linking fields, if necessary.

if physical space is an issue, when it comes to putting two subforms in the
main form, then consider using a tab control (also available from the
Toolbox toolbar). you can put one subform on each of two tabs, so they take
up less space in the form.

hth

 

[jackie]

thanks very much managed to get it to work

 

[tina]

you're welcome

thanks very much managed to get it to work

 

[SFC Traver]

This is why I always come here for help! I was having the same problem and
found the answer here. I never knew ypou could master/child link more than
one field!
Thanks all!
SFC Traver