You cannot add or change a record because a related record is required in table ‘table_name’

I just took over access website and I am trying to figure out why when i try to update a record in one table, it provides me with this message.

“Microsoft JET Database Engine error ‘80040e21’

You cannot add or change a record because a related record is required in table 'Members'. "

How do I find out what the related record is.

Thanks for any assistance

Leave a Comment