When Specifying Referential Integrity, One Way to Handle the Update

question 102

Short Answer

When specifying referential integrity, one way to handle the update of a primary key is to _________________________; that is, have Access allow the update but then automatically make the sarresponding change in any related resards in other tables.

---

Definitions:

Freight Charges

Costs associated with transporting goods from one location to another, often incurred by the seller to deliver goods to a customer.

Purchase Returns

Goods returned by the buyer to the seller, usually due to defects or otherwise not meeting expectations, resulting in a refund or credit.

Average Cost Method

An inventory valuation method that calculates the cost of goods sold and ending inventory based on the average cost of all similar items in inventory.

Ending Inventory

The value of goods available for sale at the end of an accounting period, calculated as beginning inventory plus purchases minus cost of goods sold.