After creating a Form, how do you you put four tables that have a.

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi There,

I have been asked to creat a form, which I can easily do. Then to put four
tables which are joined in a relationship to each other together. When I do
this I keep getting a message stating "The changes you requested to the table
were not successful because they would create duplicate values in the index
primary key or relationship. Change the data in the index or redefine the
indexes to permit duplicate entries and try again." How do you redifine to
allow for duplicates? Because there are 4 tables I naturally have 4 primary
keys and I also have 3 foreign keys to link everything together. Can you only
connect 3 tables together onto a form? Therefore giving you one junction
table!
--
JPC
.

Relevant Pages