Certain jobs only need certain training... How to set up...

[Cristina]

Okay, this is what I am trying to do...

I have a group of employees that need training depending on their trade and
position.

I am trying to set up a form that shows ONLY the training needed based on
the Trade and Position that is selected in a single table OR form.

I don't know how I would go about setting this up. Do I create a
table/query/macro or what?

I already have a table set up for each of the items listed (trade, position,
and courses). And I do have a form created but missing the information that
will be dropped in once I get this figured out. It's the queries that I am
having the most difficult with. I tried setting up the queries but they
weren't for some reason doing
what I was hoping for. I was linking the three tables into one query, but I'm
guessing because there was no common thread linking the tables it wasn't
quite right.

THANK YOU!

 

[Noëlla Gabriël]

Hi,

a proposal:

you already have your tables TRADES, POSITIONS and TRAININGS. Add a table
EMPLOYEES, with fields as name, first name, ect plus a field TRADE that
refers to the primary key of the table TRADES, and a field POSITION that
refers to the primary key of the table POSITIONS.
Further you create a table TRADES_TRAININGS stating which trainings are
needed for which trades and a similar table POSITIONS_TRAININGS.
Then you can start creating the necessary queries and forms to complete the
app.
success...