Forum Discussion
Running a Query based on checkboxes
Thanks for this, but this isn't about relationships; I understand relationships and have developed many databases before. I'm just struggling with the wording for my queries.
We have a product that can have many different features - I won't get into details, but they are all unique. I could create 5 tables for the different product lines we have, but at the end of the day, I'm STILL going to have the same number of checkboxes for the features. They are all unique.
With reference to the article you posted, it's not like I have Item A and I'm looking for feature 1, 2 or 3. I am ONLY looking for features. They referred to patient names and symptoms; there is no patient.
I mean, yea, I could put the identifiers in a separate table, but at the end of the day, I'm still going to have 40 unique features.
I suppose, alternately, I could create multiple queries for each feature and the user would have to select which feature they are looking for. But that isn't really the path I want to go down.
