Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Northwind question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Debbiedo - 30 May 2008 00:34 GMT
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 - 30 May 2008 05:07 GMT
On the properties of the subform. Link Child Fields and Link Master Fields
both say OrderID.

> How does the OrderID value get updated in the Order Details table from
> within the Orders form?
[quoted text clipped - 10 lines]
>
> Deb
Roger Carlson - 30 May 2008 15:20 GMT
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.

Signature

--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

> How does the OrderID value get updated in the Order Details table from
> within the Orders form?
[quoted text clipped - 10 lines]
>
> Deb
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.