Here is what I have so far:
One form that allows the addition of a new employee. All the fields are associated with a single table.
One form that allows for the editing of most of the information about that employee.
The client wants to be able to keep track of every time that employees status changes ("Temp Full Time";"Temp Part Time";"Permanent Full Time";"Permanent Part Time") and every time thier pay changes.
So my idea was that when the information is entered into the "Add Employee" form, the information in the employee status and pay rate text boxes would be duplicated into another table. Kind of like an audit log. Then every time the data was modified in the "Edit Employee" form It would have a record for the date effective and the new status or payrate.
Hope this makes sense.
Thanks in advance for your help.