match data in tables

[mkelly]

I am working on an old database that was not well thought out. My question is I have a table cammed "recievers" id contains an id, account # and location #.

I also have a table called "Purchase orders"
Among other thigs it also contains. id, account # and location #.
However, in the ID there is no data and this is what creates the relationships. I have fixed the form to record the ID rather than Account# and Loc #.

Is there a way Query to match up the old records in "purchase orders" to the ID in "recievers"?

 

[dcx693]

You can join the two tables on account# and location# and return the id from the receivers table.

 

[mkelly]

Thanks