[mikeiswayawesom]

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

 

[CTSNKY]

Run three queries in all....one for each table (dumping the results into a newly-created table) and one against the results table you create from the first two.

Or create a new table using a query with just the common information, then use that table to extract the remaining data from their respective tables.

 

[djaburg]

In the long run, would it not make more sense to invest the time to migrate the data in to one table to streamline the process of searching? Continually creating queries to compare data in two tables seems to be awfully inefficient. Just an idea.