Hello,

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?

Thanks,
Tom

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.

tblpositions
pkpositionID autonumber, primary key
txtpositionDesc

tblStaff (from your model)
pkStaff
other fields


tblStaffPositions
pkstaffpositionID autonumber and primary key
fkStaff foreign key related to staff ID
fkpositionID foreign key related to postion ID

and to display them on the form, you would use a subform.