AnsweredAssumed Answered

Searching Related Tables

Question asked by RonKanter on Apr 24, 2013
Latest reply on Apr 25, 2013 by RonKanter


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?