I think, but am not sure, that, in each line of your second paragraph, you
mean:

"If the user checks B1, then uncheck all the A's except A3 and uncheck all
B's except for B1."

Is that accurate?

If so, I'm confused about how the logic of the first set of requirements
would work with the second. If, for instance, A1 is checked, then, by the
logic of the first set of requirements, the user could only touch B1,
presumably by means of a script trigger that would return the fields to
their values before a checkbox other than B1 were entered. Having managed
that, when B1 is checked, by the logic of the second set of requirements,
all A's save for A3 would be unchecked, including the controlling A1,
which would thereby remove the conditions imposed by the first set of
requirements. While this seems doable, I'm having trouble imagining a
scenario where it would be useful.

If my descriptions are fairly describing what you're trying to do, I can't
see enough of a pattern to encapsulate the logic into anything graceful,
and I'd probably write a script with a zillion "Else IF's", one for each
possibility. The result of each successful "Else IF" would be a loop
through the checkboxes. Loops like that run very quickly; just a pain to
work out the logic.

The fact that you're even considering calculations makes me wonder if I'm
understanding the problem correctly.

John Weinshel



On 5/23/12 3:25 PM, "John Montana" <[log in to unmask]> wrote:

>Hi all,
>
>I have an application with some specific requirements:
>Layout with 2 tabs. A, B
>Fields on tab A: A1, A2 Š.. A5
>Fields on tab B: B1 Š. B8
>All fields are check boxes.
>Requirements.
>Check A1, possibility to only check/uncheck B1
>Check A2, possibility to only check/uncheck B2
>Check AŠ, possibility to only check/uncheck BŠ
>That is not hard to cover.
>
>The problem comes in with the next requirement:
>Check B1 = uncheck all A¹s and A3 is checked, uncheck all other B¹s
>Check B2 = uncheck all A¹s and A4 is checked, uncheck all other B¹s
>Check B3, B4, or B5 = uncheck all A¹s and A1 is checked, uncheck all
>other B¹s (except mentioned B¹s if they are checked)
>Check B6 = uncheck all A¹s and A1 is checked, uncheck all other B¹s
>Check B7 = uncheck all A¹s and A2 is checked, uncheck all other B¹s
>(except B2 if checked)
>Check B8 = uncheck all A¹s and A5 is checked, uncheck all other B¹s
>
>If I go with calculations, I will be probably (already are) lost in
>nested Case() or If().
>
>So, scripting seems to be the best approach, using Set Field().
>What could be the best way to code this ?
>Check if there is already a value and act accordingly, or just bluntly
>ignore all the possible existing values and just set the needed fields as
>per requirement ?
>
>Appreciate every hint.