N
NeoFax
I have a form that allows the input of personell and their
supervisor. I use the same table for both the supervisor and employee
and just update the field supervisorID to match the primary key of the
table. However, on the form I want to show the Supervisors
BadgeNumber but write the primary key number to the SupervisorID.
This is not working. I have tried pretty much everything I can think
of to do this other than duplicating the table. Here is what the table
looks like:
nameID(PK) autoNumber
FirstName Text
LastName Text
BadgeNum Text
Department Text
WorkNum Text
SupervisorID Number (should equal nameID of supervisor)
supervisor. I use the same table for both the supervisor and employee
and just update the field supervisorID to match the primary key of the
table. However, on the form I want to show the Supervisors
BadgeNumber but write the primary key number to the SupervisorID.
This is not working. I have tried pretty much everything I can think
of to do this other than duplicating the table. Here is what the table
looks like:
nameID(PK) autoNumber
FirstName Text
LastName Text
BadgeNum Text
Department Text
WorkNum Text
SupervisorID Number (should equal nameID of supervisor)