Hi and welcome to the forum, Christof.
Perhaps the simplest method is to use one Tab control (with 3 tabs—one for each of the options). This way, you can add the different fields associated with each option on its own tab. When a tab is selected, only its fields will be displayed. You do not need the checkboxes using this method since the Tab label serves this purpose.
Thank you both, Jade and Jim, for your prompt and helpful suggestions!
I understand, that my original ideas on how to address my database needs cannot be implemented the way I wished.
Will experiment with your suggestions and see which one works better for me :-)
It is possible to set up script triggers on selected fields to deny access to the field if the value in your type field indicates that these fields are not appropriate for the type. A validation rule can back up those settings by rejecting all input if the wrong type is selected. (Drag and drop can get around the script trigger, but not the validation rule.)
But I wouldn't use a check box format on the field as check boxes permit selecting multiple types. I'd use a radio button format.
Now I am really overwhelmed :-)
I guess this pretty much lays out what I am going to be trying over the weekend....
These last 2 suggestions go more into the direction that I had in mind originally.
Thank you also very much, PhilModChunk and S Chamblee!