error 3201

  • Thread starter Thread starter Roadwarrior1
  • Start date Start date
R

Roadwarrior1

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

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.
 
Roadwarrior1 said:
You cannot add or change a record because a related record is required in
table <name>. (Error 3201)
Click to expand...

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.
 
Back
Top