Jul 24 2006, 09:18 PM
I am a teacher building a database based on the model I found at http://www.databaseanswers.org/data_models...ments/index.htm
How do I assign a staff member a job title when each staff member can fill many positions at the same time (e.g. teacher, counselor and homeroom teacher)? How do I display this on the form?
Jul 24 2006, 09:50 PM
Since you state that a staff member can hold many positions, you need to create a table that links a staff member's ID to the ID's of the various positions.
I would use the following three tables. The last table links the staff member to the position(s) they hold.
pkpositionID autonumber, primary key
tblStaff (from your model)
pkstaffpositionID autonumber and primary key
fkStaff foreign key related to staff ID
fkpositionID foreign key related to postion ID
Jul 25 2006, 12:56 PM
and to display them on the form, you would use a subform.