error 3201

[Roadwarrior1]

You cannot add or change a record because a related record is required in
table <name>. (Error 3201)

 

[John W. Vinson]

You cannot add or change a record because a related record is required in
table <name>. (Error 3201)

The message means what it says. You have relational integrity defined in a
Relationship between some table (which I cannot see from here) and some other
table (which I cannot see either). You're attempting - somehow, you don't say
- to add a record to the second table, and it has a value in its foreign key
field which does not exist in the first table.

Remember: YOU can see your computer. YOU know how your database is structured.
We cannot, and do not.

 

[Arvin Meyer [MVP]]

You cannot add or change a record because a related record is required in
table <name>. (Error 3201)

When 1 builds a one to many relationship and enforces referential integrity,
the system keeps you from adding, changing, or deleting a record from the
many side, before creating a record on the one side.

This effectively, for instance, keeps one from adding or deleting an order,
if there is no customer.

To resolve the error, make sure you have a one-side record first.