Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2012
    Posts
    8

    Unhappy Unanswered: Searching across multiple tables for entrys

    Hello

    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.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You can create a UNION query on all tables and perform the search on it.

    Notice that your data model is flawed: There should be one and only one table for all operators with a column identifying the operator.
    Have a nice day!

  3. #3
    Join Date
    Mar 2012
    Posts
    8
    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?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •