georgea said:
using a access database I get this error when I try to add a record
"cannot add or change a record because a related record is required in
table"
I reckon that the problem is that you cannot add or change a record because
a related record is required in table ???.
OK, sorry to be flippant, but really, the answer is in the message! There
is a relationship set up in your database between two tables which is
enforcing referential integrity. Here's an example: an orders table would
normally have a relationship with, say, a customers table, and the
relationship would be set up to "Enforce Referential Integrity", which means
that you can't enter an order record unless the customer record already
exists (for obvious reasons).
There is a similar relationship in your database. If you click on the Tools
menu, you will see that there is a Relationships option. Clicking on that
will open a diagram showing the relationships in your database.
Right-clicking a relationship line and choosing "Edit Relationship" will
show you which relationships are set up to "Enforce Referential Integrity".
I strongly recommend that you do NOT change any relationships until you
fully understand the design of your database. Whoever put those
relationships there did so for a reason!
