Adding key to muilpe table- I am a idoit

[amfroehlich]

How can i add the same key feild to mulipe table. Access it trying to make me use a subform becuase the tables have a one-to-many relationship. But, all i want to do is create this same instace of a feild in both tables. Please help this idiot.

 

[Andrew Fergus]

Hi, a bit more information may be useful because I don't understand the problem.

You can have multiple tables with the same primary key - each key must be added to each table in the normal manner. If you wish to link the tables using Menu -> Tools -> Relationhips then Access will recognise where the tables have either one-to-one or one-to-many relationships, depending on the number of fields that are set up as keys, and create the relationship accordingly.

If you are trying to change the relationships then you need to delete the existing relationships between the tables before creating new relationships and/or keys.

I'm not sure if I have answered your question but I hope this helps.

Andrew.