Do you mean that if you select a specific value in a dropdown list, a specific subset of check box values in a second field will be automatically selected?
The OnObjectSave trigger on the drop down list could be used to perform a script that sets specific values in the checkbox formatted field. Or a table of related records could be used to create the illusion of check boxes with no scripting required.
Yes, I want to link the set of checkboxes to a dropdown list so that if I select for example the value "A" in the list, the checkboxes "aa" "cc" and "dd" show checked. And if I uncheck "cc", I want the value in the list to keep only "aa" and "dd" in memory. So every now and then, I'll be able to check and uncheck checkboxes and they will keep linked to their "parent value" in the dropdown list. Is it possible to have this kind of "database within the database"?
This is definitely possible and there is more than one way to do it. The simplest approach "hardwires" the values to the script and requires modifying the script to change what values are selected. A better approach, what I am about to describe, copies the values from a related table. This approach allows you to update what values get selected without having to update the script.
And you can set this up so that selecting a value in the drop down list clears existing values selected in the check box field or it can add the associated values to those already selected...
Set up a related table of check box values:
MainTable::DropDownListFIeld = CheckboxValues::Category
Now a script can be used to add the associated values from CheckBoxValues to your check box field in MainTable to those already selected or an auto-enter calculation can simply replace all currently selected values with the values from CheckboxValues.
The script, performed by an OnObjectSave trigger on the drop down list:
Set Field [MainTable::CheckboxField ; List ( MainTable::CheckBoxField ; List ( CheckboxValues::CheckBoxValue ) ) ]
The auto-enter calculation that can be specified for field options for CheckBoxField:
List ( CheckBoxValues::CheckBoxValue )
and then you clear the "do not replace existing values..." checkbox