Tables and form design

[Fysh]

I am trying something different here and I was hoping someone might have a
suggestion. What I am attempting to do is create a form from a table related
to other tables as follows.

tblCategory tblActivity tblQualType
CATID ACTIVITYID QUALTYPEID
Category Activity Qual

tblSetup
SetupID
Required yes/no
Enabled yes/no
Applicable Value list
CATID
ACTIVITYID
QUALTYPEID

Now that the tables are set up, I am trying to create a form which will show
all the categories, select an activity and a qual type. Next to each
category have a check box for the required field and one for enabled field
and combo box for applicable.

Once the form is filled in have it create or update the table. Create a
query from this table. On another form when an Activity combo box is
selected have it process the query and update the fields on that form. I
know I have to create the code to accomplish this.

I tried using a subform, but that didn't work. I tried a continuous form
that didn't work.

My question is looking at my tables and my first form is this possible, if
so how? If not how would you suggest doing this? Any support would be
appreciated, thanks in advance.