Error in large table?

[Stephen]

I recently amalgamated three tables into one. I had a form
based on each table, but now have the three existing forms
all based on the single amalgamated table. I continually
get the error message

"The changes you requested to the table were not
I have tried to redefine indexes, allow duplicates etc.
Even deleted the large table and reformatted, but still
the error occurs.
Grateful any help on solving this one.

 

[MacDermott]

If you have 3 forms all based on one table, you may run into problems if you
change data in one, then move to another without saving the changes in the
first.

Also -
have you compacted your database recently?

- Turtle

 

[Rolls]

The error suggests that something is attempting to append a record that
duplicates a unique field. The fact that you WANT this to occur suggests
that your tables aren't normalized.

Please give an example of what is in the table and the intended purpose of
each form.