Table Design and Fields?

  • Thread starter Thread starter Chertsey
  • Start date Start date
C

Chertsey

I have a table that has School data in it. I need to be able to indicate that
a specific school has numerous options that can be designated to it - or not.
There are 8 options. The selection can be a combination of any or all of the
choices. Some of the options would be for example "WheelChair Access", "Deaf
& Hard of Hearing" and others. Does the fact that I can choose more than one
of the options preclude me from using an Option Group and thereby forcing me
to create a field for each of the choices, that may in most cases be blank.

Regards
 
Hello Steve,
This problem sounds a lot like a problem i am having in a post "Table Design
or Report Design?". This sounds like what i need to fix my problem, but I do
have one question. How would you go about populating third table? I would
assume you would have a separate record for each option. For example, you
could have
School1,Option1
School1,Option2
School1,Option3
School2,Option2
How would you set up the forms, subforms, etc to achieve this. thanks.
 
Gina,
Those questions are the exact point of my post and are the questions that
need to be answered!
 
Back
Top