Re: Link Fields with Different Names

324 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

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