Sharing different interfaces with different people

[Christian_Tyler]

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.

[Jason_Gillman]

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