Selection based on multiple criteria HELP
Hi there everyone, I need some help...
I have a primary contact table, linked to many one-to-many and many-to-many relationships to contact attributes. For example:
- A contact can belong to an organization (only one)
- A contact can have special skills (many)
- A contact can have interests (many)
...and so on. My attributes amount to about 20 additional tables, with the attributes, and then also many-to-many link tables. For example:
*Contact Table*
contactID
organizationID (one-to-many)
*contact_interest Table* (many-to-many)
contactID
interestID
*Interest Table*
interestID
Now...I have combo boxes that will allow the user to select certain attributes, and then the app needs to select and create results that list all the contacts that fit the criteria.
I need help in how to go about doing this?? There are many ways I suppose, but what would be the easiest, and most efficient way to do this?
Please, any advice would be much appreciated!