Link Fields with Different Names


#1

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.


#2

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

Selection_806

Selection_807