PascalB82 Posted February 27, 2011 Share Posted February 27, 2011 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 More sharing options...
bcooney Posted February 28, 2011 Share Posted February 28, 2011 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 More sharing options...
Recommended Posts
This topic is 4804 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 accountSign in
Already have an account? Sign in here.
Sign In Now