Filling a textbox with required training with provided job position.

[hcuk]

I wasn't sure how to word the title, but i hope somebody understands it. I'm fairly new to access, and I'm trying to create a data base of employees. So in my table, I have the employee name, address, position, etc. I want the form to show what training they need for the position they are hired for. I am not sure how I could go about doing this. i.e. Position is cashier, and they have 4 kinds of training to do, I want the form to list the training that is required. This form is a profile of the employee that is going to be printed. Thanks in advance!

[June7]

Table of training courses.
Table of positions.

Can each course be associated with multiple positions? If so need another table that will associate courses with positions.

tblPositionCourses
PositionID
CourseID

[hcuk]

I made another table,
The 1st row contains all the positions and rows under each position contains the type of training that is required.

[June7]

That is not a properly normalized table.

Should be a field for PostionID and a field for CourseID. A record for each possible combination.

[hcuk]

That is not a properly normalized table.

Should be a field for PostionID and a field for CourseID. A record for each possible combination.

ahh i see. This is a different table, how would i add this information on the an existing form that contains the employee info.

[June7]

I don't know that you should. Forms are intended for data input, sounds like you need to do data output.

Build a report based on query that joins Employee table with the tblPositionCourses table, linking on the PositionID fields. Now you know what courses the employees must complete.

[hcuk]

I don't know that you should. Forms are intended for data input, sounds like you need to do data output.

Build a report based on query that joins Employee table with the tblPositionCourses table, linking on the PositionID fields. Now you know what courses the employees must complete.

Ok after joining them, I kinda have the query showing up the right training. But I want to be able to query about 1 employee, and then print the report for that employee. Also, when i print the report, I only want to print the report of the employee that I query about.

I've tried printing the report, but it repeats the employee name and all the other employee info if the employee has more than one training. I want the training part of the report to print all the training in one go. Not sure if access does multi-line textboxes.

Sorry for all the questions, im pretty new at this. .

Is it possible to create a hyperlink from access to a specific sheet in excel. The reason im doing this, the training that the employees are doing are forms thatI created in excel.

Edit: Been playing with the report in design view, maybe I should use a list box, but when I do that, there are alot of repeated values in there, and all the training that is available shows up.

[June7]

Listbox on report not a good idea.

If you don't want the employee name, etc info to repeat on each line, then set textbox HideDuplicates property to Yes or use Grouping & Sorting features of report. Here is one way to filter report: http://datapigtechnologies.com/flash...mtoreport.html

Yes, Access can link to Excel sheets. Use the Import/Export wizard.

[hcuk]

Is it possible to list all the training of the employee in this one text box? instead of listing the employee again if they have additional training?

[June7]

That would require VBA code.

Don't understand the issue. I already offered two options for not displaying repeats of the employee info. Basic Access functionality. Access Help has more guidance on both.