Solved Cannot add record because a related record is needed in another table - unable to find cause

[isladogs]

See if my 3 part series of articles on relationships & referential integrity helps your understanding
The first article is :

Relationships1

This article discusses the differences between query joins and table relationships and explains the important use of table relationships to enforce referential integrity. Three methods of adding relationships are discussed. The article also explains how Access uses the MSysRelationships system...

www.isladogs.co.uk