SUBFORMS HELP PLEASE!!!!

G

Guest

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
 
G

Guest

Sounds like you are on your way. Just create a subform off the training
table. Place that on your main form and make the Child and Master link
properties to be Role. When you pick a different role on your main form, it
will change the data on the subform to just reflect that role.

Hope this helps. Let us know if you need more specifics.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top