Help me fix my access database?

[-Mike-]

Hi all,

Am in the midst of creating an access 2007 database which keeps throwing up the error "You cannot add or change a record because a related record is required in table "customer"


Can anyone offer me a solution as to why its doing this, please?

 

[NutterzUK]

Ok, do you have relationships between the table you're working on and the table you have named Customer? If you have something ticked saying " Enforce referential Integrity " on the relationship, that may be the problem.

 

[NutterzUK]

If you're having big problems with it still, and so long as there is no confidential information in the database ( if it's empty ), you can send me the database file and I will have a look. Obviously that is not an option if it has data in it.

 

[Spuds]

Sounds like the table you are editing has a relationship with a customer table, presumably a field in the customer table is a foreign key in this table. By the sounds of the error you are trying to add or edit a row in which case you need to make sure the value you are entering in the foreign key field exists in the customer table before you add the data to the second table.