Northwind question

[Debbiedo]

How does the OrderID value get updated in the Order Details table from
within the Orders form?

If I add an order to the Order table from within its table view and
then open up the Orders form and enter data in the subform section,
this data is updated into the Order Details table along with the
OrderID from the Details table.

I cannot for the life of me figure out where this value is getting
passed from the Orders table to the Order Details table.

Thanks in advance for any clarification you can provide

Deb

 

[Tammy F]

How does the OrderID value get updated in the Order Details table from
within the Orders form?

If I add an order to the Order table from within its table view and
then open up the Orders form and enter data in the subform section,
this data is updated into the Order Details table along with the
OrderID from the Details table.

I cannot for the life of me figure out where this value is getting
passed from the Orders table to the Order Details table.

Thanks in advance for any clarification you can provide

Deb

 

[Roger Carlson]

The subform control takes care of adding the foreign key value to your
subtable based on the primary key value of the main table. That's one of
the things that makes the subform so powerful.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L