How do I set-up a complex relationship in Access

[Guest]

I am new to the use of relationships in Access. I can set the relationships
up, but when I try to set-up the ralationship with more than one table
attached to the main table only one will show regardless of how many tables I
have jioned via the relationship. Can someone help me to set up
relationships (as you would find on the Tradewind database (within help)

Thank you very much

 

[Guest]

Where do you go to set up relationships?

If I'm understanding your question rightly, what I've learned is that you
cannot use the wizard to make a form with more than one subform. Instead,
you must create forms for the child tables first, and then in design view for
the parent form, you drag and drop those subforms in.

 

[Guest]

If I'm understanding your question rightly, what I've learned is that you
cannot use the wizard to make a form with more than one subform. Instead,
you must create forms for the child tables first, and then in design view for
the parent form, you drag and drop those subforms in.

 

[Brian Bastl]

Ricter,

You're correct that the wizard will only allow you to create one subform
control at a time, but you can add as many subform controls as you like
*using the wizard*. And the subforms don't have to be in existence as
stand-alones to do this. The wizard gives you two options: 1 - using an
existing form; or 2 - creating the subform from an existing table or query.

HTH,
Brian