ben h wrote:
> I don't know how best to describe this, except with an example of what i
> want to do:
>
> A table in MS Access 2000 holds choices made by a user in response to a
> series of questions, but for each question in the response (a response
> equates to a record) there is a rule that if she chooses (a or b) for
> any question in that response, then she can't choose anything else for
> that response.
>
> So, for response 1, there are 6 questions each having 5 options. From
> the 5 options, she can choose from a,b,c,d, and e. She can select an
> option from more than one question, unless she chooses a or b in any of
> them, in which case that's the only question she can respond to.
>
> Basically you can imagine it by thinking of a form, showing multiple
> rows. For each row, there are 6 combo boxes with the 5 choices. The user
> may choose anything she likes in a row unless in any of the combos she
> chooses a or b, in this case that is all she shall be allowed to select
> for that row, the rest must remain empty.
>
> The tables look like this:
>
> [table] Responses
> id (PK)
> Q1
> Q2
> Q3
> Q4
> Q5
> Q6
>
> [table] Choices
> id (PK)
> choice
>
>
> I've tried using a SQL query but I'm not having much luck, would anyone
> have a suggestion?!
>

Mike Brind wrote:
>
> Prevent someone selecting more options after they have selected a or b?