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.
