4 Replies Latest reply on Apr 25, 2013 7:11 AM by RonKanter

    Searching Related Tables



      Searching Related Tables


           I have three related table, a primary one, which contains one record per person and two related tables which may have multiple records per table.  For example,the primary db may have a record for John Smith and on of the other tables may have a list of cars he owns.  The third database coule be a list of sports he likes.  I need to ability to search all tables at once.  For example, find me all people who own a Porche, a Ford and that like Tennis and Baseball.  All searches will be using 'and' not 'or'

           Any suggest how best to do this?