Update detail record through form

[Craig]

Hello. I'm using Access 2003. My question is how can I update the detail
(child) ID field if the user changes the header record through a main
form/sub form?

ex.:

Header
----------
1 | Joe Smith
2 | Sally Jones
3 | Frank Adams

Detail
---------
1 | 1 | Joe Smith detail
2 | 1 | Joe Smith detail
3 | 1 | Joe Smith detail
4 | 2 | Sally Jones detail
5 | 2 | Sally Jones detail
6 | 3 | Frank Adams detail
7 | 3 | Frank Adams detail

If the user changes the value in the combo box from Joe Smith to Sally
Jones, the detail records need to update to reflect this. How do you do
this??

Thanks for the assistance.

 

[Craig]

Yes, that's true.

However, when the user changes the combobox value, how does the headerID
field in the detail table get updated?? As it stands right now, IT DOES NOT.

Thanks.