C
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.
(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.