Updating Records in a Query
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.
Update Records in One Table
Let's first review ...
Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
