Jump to content

Lookup from 2 different tables ?


PascalB82
 Share

This topic is 4362 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 ?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4362 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.