Use an tickbox on continous form to select?

[Henrootje]

Dear people,

I am trying to do s'thing that should be pretty straightforward but I
can not get it to work

Table 1: List of Countries -> Countrycode, CountryName (all text),
Selected (Yes/No)
Table 2: List of Documents -> Documentcode, Text, Explination,
Additional info (all text)
Table 3: Connectingtable (containing the PK of table 1 and 2 as FK) and
Yes/No fields for xResident, xNONResident, xNew and xModification

The applicationcontroller has a form in which the countries are listed.
For each country he can select (in a subform) which documents are
eligible for that country. Furthermore he can select for each document
how it should be used (Resident, NONResident, Modification, New)
This works like a charm.

Now, the users need a form in which all the countries are listed.
Per country there should be a checkbox 'Resident', 'New', 'Select'

If the select is 'on' it should be printed
If the Resident is 'on' it should select _for that country_ all
documents that have the 'xResident' on, otherwise the 'xNONResident'
If the 'Modification' is 'on' it should select _for that country_ all
documents that have the 'xModification' on, otherwise the 'xNew.

The first one I figured out by simply using the 'Selected' from the
countrytable, using 'True' as criterium.
I have a lot of trouble with the second and third.

Any suggestions as how to do this?

Thanks a lot in advance,

Henro