B
_Bigred
I have a
UnitMaster table that contains a field "HireDate" and a field "JobCode". The
Job Code is filled in by using a lookup field so the user doesn't have to
manually type in a JobCode (to avoid incorrect input).
I also have a table "JobAssignments" it has fields "HireDate" and "JobCode".
How do I - in UnitMaster select a JobCode for a person, and have this
automatically entered in the "JobAssignments" table?
Ultimately this JobAssignments table gets updated very frequently, so I
would like to be able to have the database user designate which person has a
particular JobCode and HireDate in the UnitMaster table, and have it
populate the JobAssignments table when changes are made.
What is the best method to accomplish this, hopefully I have provided clear
information about what i'm trying to do. If you need more info just reply.
TIA,
_Bigred
UnitMaster table that contains a field "HireDate" and a field "JobCode". The
Job Code is filled in by using a lookup field so the user doesn't have to
manually type in a JobCode (to avoid incorrect input).
I also have a table "JobAssignments" it has fields "HireDate" and "JobCode".
How do I - in UnitMaster select a JobCode for a person, and have this
automatically entered in the "JobAssignments" table?
Ultimately this JobAssignments table gets updated very frequently, so I
would like to be able to have the database user designate which person has a
particular JobCode and HireDate in the UnitMaster table, and have it
populate the JobAssignments table when changes are made.
What is the best method to accomplish this, hopefully I have provided clear
information about what i'm trying to do. If you need more info just reply.
TIA,
_Bigred