Need help with relationships

[Mugen2k2]

Hi to all!

I'm new an I need some help! Would like to know how to make a relationship between 1 and 6 other tables! I have to connect the 6 tables with the one primar table!! My problem is that once I choosed the relationship and I open the primar table, access asks me with which of my tables I would like to create the relationship! And then I can choose only one table!! PLS HELP ME!!!
Looking forward to an answer from you,

yours faithfully

Daniel

email:daniel.zanetti@eminem.com

 

[Bastien]

Goto TOOLS>Relationships and set all the relationships there...

hth

Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[Mugen2k2]

Hi, that's what I have done!! And then if I go back to the main table, access asks me to choose one of this table (with whom I made the relation before). I can only choose one table but I need them all!

by

daniel

 

[momon]

Ok... I think this might work.
Go to the relationships page and add all the tables that you want to be included in your relationship.

Now,
1) Click the field in the primary table and drag it to the field in the foreign table to which you want there to be a relationship

For example, the primary table contains the fields brand and type, and the foreign table contains the fields brand and cost. To form a relationship drag the brand field from the primary table to the brand field in the foreign table.


2) Repeat this for all of your remaining tables.