TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Specs
NA
2
0
Selection based on multiple criteria HELP
Apr 24 2008 4:03 AM
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!
Reply
Answers (
0
)
manipulate two different database using c#
the question about BitVector32.Section