I know newer versions of MS Access allow multiple selections in lookup fields.
For example, if I'm collecting information on my students, I can have a field called
Race with lookup values that include
White, Black, Hispanic, Asian, etc. and then set that to allow multiple selection.
In term of db design, is it better to use this feature of Access.... OR to have a field for each Race category and then True/False values for each one? And maybe even have this in a separate table?
I'm asking my question about the table, not the form. I realize the front-end display is not identical to the back-end strucure. Is it better to have a bunch of true/false fields in the table OR just one lookup field that allows multiples? (knowing the form is the best place to define the actual lookup values)