If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Northwind question
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 |
#2
|
|||
|
|||
Northwind question
On the properties of the subform. Link Child Fields and Link Master Fields
both say OrderID. "Debbiedo" wrote: 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 |
#3
|
|||
|
|||
Northwind question
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/...UBED1=ACCESS-L "Debbiedo" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|