Lookup from 2 different tables ?

[PascalB82]

Hi there !

I have 2 tables in the same file that are almost identical. Table A has a field with a serial key in the 0001 format. The Table B has also a serial key but in the format FIT 0001. In another table, I want to be able to lookup from both tables. Is it possible ?

[bcooney]

Hello. I have to say, this sounds like a poor design. Table B's serial key sounds like a calc or user-entered data, is it?

It would be helpful to hear more about your structure and why you have two tables that are so similar. Also, please provide more detail about the lookup.

Thanks,

Barbara