K
kelly d via AccessMonster.com
The Northwind DB, access-101 which I'm certain everybody is familiar with,
the orders form, when you enter a new product into the orders subform that
gets recorded into the order details table, how does that subform know to
associate that new entry in the subform with the orderID from the main form
when recording that entry into the table. I couldnt see any relationship or
event procedure that would tell the order details table what orderid to
associate with the entries in the subform. I saw the subforms link-field was
set to orderID but I didnt think that link-field could also auto-populate a
field (such as the orderID field) in a table when a new record is added to a
subform.
Would anybody be willing to offer an explanation as to how the subform knows
what orderID to put into the orderID field of the order details table when a
new record is added to the order subform.
Thanks.
Kelly D
the orders form, when you enter a new product into the orders subform that
gets recorded into the order details table, how does that subform know to
associate that new entry in the subform with the orderID from the main form
when recording that entry into the table. I couldnt see any relationship or
event procedure that would tell the order details table what orderid to
associate with the entries in the subform. I saw the subforms link-field was
set to orderID but I didnt think that link-field could also auto-populate a
field (such as the orderID field) in a table when a new record is added to a
subform.
Would anybody be willing to offer an explanation as to how the subform knows
what orderID to put into the orderID field of the order details table when a
new record is added to the order subform.
Thanks.
Kelly D