hi,
I have a table for job history that contains the history of the rotations between the departments for specific employee
then
I have form for Edit employees and I need when I open this form on specific employee and edit the department textbox to insert new record with new department and start date ( date of edit) and end date (today) as long as he still in the same department
I am using bound controls in my form
any suggestion would be appreciated
thank you very much