Question about: "Dynamically search multiple fields" by John Big Booty

[eduardo]

I've been using this wonderful code for quickly searching records on my database:

http://www.access-programmers.co.uk/forums/showthread.php?t=188663

My question is:

The code currently works for searching data on ONE single table.
What if I wanted it to search data simultaneously on TWO similar tables?

I was messing around trying to build up a query that uses both tables but it failed. Any ideas?

Thanks!

 

[Beetle]

So you have 2 different tables with the same (or very similar) fields/data?

This is usually an indication of improper design, but perhaps you can elaborate a bit on your situation.

 

[eduardo]

So you have 2 different tables with the same (or very similar) fields/data?

This is usually an indication of improper design, but perhaps you can elaborate a bit on your situation.

I have one table for each type of mortgage, let's say mortgage type "H", numbered from 1 to infinite in one table, and mortgage type "T" numbered same way, in a second, independent table.

Sometimes a random person shows up and says "I'm Mr. John Doe".

I need to quickly search for his name in both tables at the same time, no matter if he is H or T.

I know the system may seem awkward, but it is based on an old physical archive that I can't modify because it's huge, so I have to adapt my database to it

 

[eduardo]

Well, I finally could figure this out, it was pretty easy actually.
In case anyone ever needs to know how to do it, I'll be glad to help.