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

[FindJune]

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!

 

[Arvin Meyer [MVP]]

Something that you have added is causing 1 of the Foreign Keys to be written
to a Primary Key. Try re-writing the query adding one table at a time.

 

[John W. Vinson]

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!

STOP.

Tables (and their relationships) are primary.

Forms are secondary, designed to fit the tables - NOT vice versa!

When you build a house you pour the foundations before you start assembling
the frame!

What are your tables? How are they related? Did you use a Form based on the
"one" side table with Subforms based on the "many" (perhaps a sub-subform if
you have a one-to-many-to-many relationship), which would be correct, or try
to base the form on a query joining all four tables (very unlikely to work)?