H
Hem
I have made a access database to monitor my departments training needs. We
have a number of roles each which require specific training. I want to creat
a subform in my main form which shows the training required by each role when
the role is chosen on a drop down menu on the main form. I have created a
table with the four roles and the 'Role:' field in the main form is linked to
that. Then i have created a table with each of the four roles and the
training required by each role e.g.
role training required
ROLE 1 Training 1
ROLE 1 Training 2
ROLE 1 Training 5
ROLE 2 Training 1
ROLE 2 Training 7
ROLE 2 Training 9
ROLE 3 Training 2
ROLE 3 Training 8
ROLE 3 Training 6
Can anyone help on how to make this subform please?? Thanks in advance, Hem
have a number of roles each which require specific training. I want to creat
a subform in my main form which shows the training required by each role when
the role is chosen on a drop down menu on the main form. I have created a
table with the four roles and the 'Role:' field in the main form is linked to
that. Then i have created a table with each of the four roles and the
training required by each role e.g.
role training required
ROLE 1 Training 1
ROLE 1 Training 2
ROLE 1 Training 5
ROLE 2 Training 1
ROLE 2 Training 7
ROLE 2 Training 9
ROLE 3 Training 2
ROLE 3 Training 8
ROLE 3 Training 6
Can anyone help on how to make this subform please?? Thanks in advance, Hem