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?