Have two fields reference the same field

  • Thread starter Thread starter William W
  • Start date Start date
W

William W

Hello,

I am trying to have two fields (ISBN) and (Product ID)
reference the same field (ISBN without dashes) in another
table to retrieve the info in the (Title) field.

So I want to have two potentially different fields check
to see if there is a related record in another table, and
if there is retrieve the Title.

I keep getting an ambigious outer join error and cannot
understand the joining properly to make it work...

Any ideas/clarifications on how to do this?
Thanks
 
William W said:
Hello,

I am trying to have two fields (ISBN) and (Product ID)
reference the same field (ISBN without dashes) in another
table to retrieve the info in the (Title) field.

So I want to have two potentially different fields check
to see if there is a related record in another table, and
if there is retrieve the Title.

I keep getting an ambigious outer join error and cannot
understand the joining properly to make it work...

Any ideas/clarifications on how to do this?
Thanks
Click to expand...

The message is correct. Your tables are designed wrong.
If ISBN and Product ID are always the same, which I doubt, there is no need
for one of them.
If not then a one to many with ISBN (?) with Product ID as the key in the
other table would be better.
You will either have to fix it or use dLookup in code a few times to do
what you want.
 
Back
Top