J
Jon E
Hi,
I would like to search for people on the basis of what sports they play.
For instance, lets say that I had a form with 3 checkboxes: basketball,
footbal, and baseball. I want to be able to click basketball on the form and
pull up all the records for people who play basketball. If I select
basketball and football, I want to find all records with either basketball
or football in their recdords.
How exactly should I set up the tables for this? In other words, how should
I store this information? Should the table have a field like "PersonID"
(linked to another table with info for this person) and then three separate
"Yes/No" fields for basketball, footbal, and baseball. Or, should the table
include only two fields: "PersonID" (a lookup column linked to the "persons"
table) and "SportsID" (a lookup column linked to the "sports" table,
including all three sports). If the latter is the better method, then how
would I use checkboxes with a form that enables me to search for these people
via the sports that they play?
Any assistance would be greatly appreciated!
-Jon
I would like to search for people on the basis of what sports they play.
For instance, lets say that I had a form with 3 checkboxes: basketball,
footbal, and baseball. I want to be able to click basketball on the form and
pull up all the records for people who play basketball. If I select
basketball and football, I want to find all records with either basketball
or football in their recdords.
How exactly should I set up the tables for this? In other words, how should
I store this information? Should the table have a field like "PersonID"
(linked to another table with info for this person) and then three separate
"Yes/No" fields for basketball, footbal, and baseball. Or, should the table
include only two fields: "PersonID" (a lookup column linked to the "persons"
table) and "SportsID" (a lookup column linked to the "sports" table,
including all three sports). If the latter is the better method, then how
would I use checkboxes with a form that enables me to search for these people
via the sports that they play?
Any assistance would be greatly appreciated!
-Jon