Joined
·
1 Posts
Hello,
I work at a firm with about 60,000 issues broken up into two separate tables for two separate clients. The types of data in these two tables is the same but the fields have different names and the data is formatted in different ways. The one piece of information that if formatted the same in both is SS#. When documents come in I need to search through both tables using an index number (formatted differently in both but can search "any part of field" to get it) to find out where it should be filed. Some things appear in both databases others only in one. Is there a way I can query both of these simultaneously in order to save time? How? In other words, I want to do a parameter query and see all the results from both at once. What type of relationship would have to be created between the two tabes? I am so confused. :4-dontkno
I work at a firm with about 60,000 issues broken up into two separate tables for two separate clients. The types of data in these two tables is the same but the fields have different names and the data is formatted in different ways. The one piece of information that if formatted the same in both is SS#. When documents come in I need to search through both tables using an index number (formatted differently in both but can search "any part of field" to get it) to find out where it should be filed. Some things appear in both databases others only in one. Is there a way I can query both of these simultaneously in order to save time? How? In other words, I want to do a parameter query and see all the results from both at once. What type of relationship would have to be created between the two tabes? I am so confused. :4-dontkno