Suppose you create a query. You review the records and want to make some changes to the stored records in the underlying table(s). Will your editing be successful?
The dreaded answer is, “It depends.” Let's try entering records in a query under different conditions to see what works and what doesn't.
I'm using the Categories and Merchandise tables for this example. In the Database window, choose Tools, Relationships to open the Relationships window. As you've seen previously, the two tables have a one-to-many relationship through the CategoryID field. The Categories table is on the “one” side, and the Merchandise table is on the “many” side. Close the Relationships window.
Let's first review ...