OptionGroups

[alliandrina]

First I am working with a database that I think is non-normalized. I didn't create and I can't get a hold of the person who did. I have made an attempt to normalize the data but because of my unfamiliarity with the system, my need to enter data, and my bosses desire for reports- I keep getting stuck.



That said, I have a couple of questions. As I do plan on trying to normalize the database when I have a chance- the place I finding I'm having the most difficulty is with the table that records the participants response to the survey questions. When I set the option groups to record the answer response column and then checked the survey to see if it worked- none of the selections would stay selected but click off when I chose another even if in another group.

I think part of that problem comes from a specific form design that the boss wants for the system- which I can't change. And part of it is also that I am not understanding the structure for a survey database, esp when I already have a lot of data.

My other question is that since I have to work with what i have until I can create a normalized database- I need help trying to analyze the results of the option group selections. Not only do I need to determine how many of the participants selected a specific option but I also need to have that selection filtered by dates. I have a couple of ideas that I am working on but I always could use some advice.


Thank you in advance!!!!

[NTC]

An option group, if it is bound to a table's field - puts a value into the field that one can query on. The default is simply 1,2,3,4 in order of the appearance of the choices. Looking directly at the table you would see this value.

An option group that is not bound still generates that same value - - the only question is what the original designer is doing with it. Generally it is the AfterUpdate event of the control that triggers some use of the value in another field.

You should have no problem filtering/quering for an option group value.

Hope this helps.