How do I use the same column twice

[Fost]

I have three tables

CallHisyory
Clients
Locations

CallHistory has three columns

ClientID
OriginID
DestinationID

Using excel I have indexed CallHistory.ClientID to Clients.ID
And CallHistory.OriginID to Locations.ID… so now I can see the origin address(Locations.address and Locations.state) but what do I do
About the destination address
I can't use Location.address and Location.state again…
What am I doing wrong?

Thanks for helping
Fost

 

[pbaldy]

In a query you would add the locations table twice. Join the origin field to one instance and the destination to the other.

 

[Fost]

That was easy

Thank you

 

[pbaldy]

Happy to help!