I 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?
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?
