Unanswered: Searching across multiple tables for entrys
I have a database that has a table for each operator where they load in information about client cases in. I need a way of being able to search on criteria that will locate the data entry across all the tables? Is there a way (like excel) to search all tables within the database? Any help would be extremely helpful.
In a perfect world i would like one table and the mail merge to filter from the op and a drop down menu to select the template which does it automatically but we have multiple operators who create letters to send Death certs etc back to the client using special templates so we have to have a separate form per op so its all in one place. Is there no shortcut to search all forms in a doc at all?