Link Fields with Different Names


Is it possible to link fields with different names.

I have a table with a list of customers. These customers need to be linked to an assignment table. The assignment table tracks pickups and deliveries. The assignment table looks like this:

ShipperID 1
ShipperID 2
ShipperID 3
ReceiverID 1
ReceiverID 2
ReceiverID 3

There can be multiple pickups and delivers in each assignment. Customers can be shippers or receivers depending on the assignment.

I want to have one customer table and be able to link them to each of those fields in the assignment table.

Any ideas would be greatly appreciated.


Just create multiple fields that link to the particular table and name as appropriate.