T
timbotimbo
have a main employee table - employeetable - with standard fields - ie name,
address, age etc.
i have other tables to store training courses.
The fields are made up of the 'Company' who runs the course, (so have called
the field 'TrainingCompany') and the course subject , (so have called the
field 'TrainingSubject'). there is going to be about 30 different companies
and 30 different types of course, with some companies offering the same. I
need to design the tables so that i can run a query that finds only one
particular course but cannot figure out how to do this.
I've tried a seperate table for the companies names to be stored after input
( ie a combo box is used to select the company - so if we had to use a new
company then the combo box would be altered ).
the table had fields - TrainingCompany1 - TainingCompany2 .......... upto
TrainingCompany30.
I've done the same with the course subject .
the table had fields TrainingSubject1 - TrainingSubject2 .......upto
TrainingSubject30.
Even tried with a seperate table with TrainingCompany1 and TrainingSubject 1
in it.
a seperate table for TC2 and TS2, another for TC3 and TS3.
However cannot design a query to find only one course and send only that
courses
description and expiry date to a report :- example :-
Lets say there are only four courses. H&S course, First Aid course , Fire
Drill course, a Forklift Truck course and a Manual Handling Course. All
courses have expiry dates and dates when the course was taken. Lets say there
are ten differenent companies and some provide the same course. And each
employee could take the courses in different orders.
Now lets say we need someone who has a current first aid certificate - and
there happens to be 3 people and they took different course at different
times.
what would the tables and query look like ?
address, age etc.
i have other tables to store training courses.
The fields are made up of the 'Company' who runs the course, (so have called
the field 'TrainingCompany') and the course subject , (so have called the
field 'TrainingSubject'). there is going to be about 30 different companies
and 30 different types of course, with some companies offering the same. I
need to design the tables so that i can run a query that finds only one
particular course but cannot figure out how to do this.
I've tried a seperate table for the companies names to be stored after input
( ie a combo box is used to select the company - so if we had to use a new
company then the combo box would be altered ).
the table had fields - TrainingCompany1 - TainingCompany2 .......... upto
TrainingCompany30.
I've done the same with the course subject .
the table had fields TrainingSubject1 - TrainingSubject2 .......upto
TrainingSubject30.
Even tried with a seperate table with TrainingCompany1 and TrainingSubject 1
in it.
a seperate table for TC2 and TS2, another for TC3 and TS3.
However cannot design a query to find only one course and send only that
courses
description and expiry date to a report :- example :-
Lets say there are only four courses. H&S course, First Aid course , Fire
Drill course, a Forklift Truck course and a Manual Handling Course. All
courses have expiry dates and dates when the course was taken. Lets say there
are ten differenent companies and some provide the same course. And each
employee could take the courses in different orders.
Now lets say we need someone who has a current first aid certificate - and
there happens to be 3 people and they took different course at different
times.
what would the tables and query look like ?