Filtering using a user defined custom form and unbI need to be able to return a list of records from 3 tables that are related: Contacts, ContactsLanguages(one to many relationship to contacts) and ContactsInterests (one to many relationships to contacts)., , I need to be able to search by 6 different fields. 4 from the contacts table (Name, Country, Area, LastName), 1 field from the ContactsLanguages (language) table and one field from the ContactsInterests (Interests) table., , I would like to be able to have a form with these 6 search fields and when a 'query' button is selected it would filter those fields (using AND statements) and return the results below those fields displaying each record one after another., , Any ideas? | 4 replies. Last post: |  jdschram | BTW..it is a modification on the Northwinds DB that you should already have :) |
|