Hello,

I have an application with a person table where name, address, etc information is stored. I also have a child aka table where people's alias names are stored. John Jones may have an aka of "Red Dog" or Mary Smith may have re-married and now be Mary Jones.

Is there a way to search both tables at the same time and return one recordset with matching records from both tables? If I search on "Red Dog" I want John Jones to appear in the result. If I search on Mary Smith, I want Mary Jones to appear in the result.