For starters, I am using Access 2002. I am not smart enough to even ask this question clearly, so I will make an example and then ask the question:
tblWorkOrder includes maintenance work requests for an apartment building. The primary key is WorkOrderNumber. The field tblWorkOrder.LocationID...