Hi, this is more of a planning problem. I'm stuck on a method of attack!.
I have a multiple tab form, with subforms on most tabs. The main form populates from a multiple set of querys, rendering the main form un-update-able. Most the data relates to an Employee.
The subform in question records Job Positions, for which the DivisionID is an indexed key here and in the Employee record.
New job position are entered on the subform; previous one is end dated and new record has no end date. (a basic continious form)
I want to be able to update the Employee table with the latest DivisionID, and really not sure on a road to take. Have thought about an SQL update using the DoCmd RunSQL, but it looks cumbersome.
Any thoughts on a best way through this?
I have a multiple tab form, with subforms on most tabs. The main form populates from a multiple set of querys, rendering the main form un-update-able. Most the data relates to an Employee.
The subform in question records Job Positions, for which the DivisionID is an indexed key here and in the Employee record.
New job position are entered on the subform; previous one is end dated and new record has no end date. (a basic continious form)
I want to be able to update the Employee table with the latest DivisionID, and really not sure on a road to take. Have thought about an SQL update using the DoCmd RunSQL, but it looks cumbersome.
Any thoughts on a best way through this?