2. ASPRunnerPro General questions
  3. Employee Training Register
This topic is locked

Employee Training Register

 		3/24/2009 18:10:24
ASPRunnerPro General questions
A
 Aussie Mick author

G'day folks
I am looking to build a simple training register that an HR Department could use to manage the training of employees.
What I would ideally like to achieve is that there would be all employees listed in the application.
A representative of HR could Add new training modules and then go into the employee record and add a completed training module to that employee.
The problem I forsee is I am not sure how to add details of completed training to a employee file without prelisting all training and doing it on a yes no basis. I want to be able to add a training module to the training database and then go to the employee record and add that module to their account.
Could someone point me in the right direction to start this project if it is possible.
Thanks
Mick
J
 		Jane 3/25/2009

Mick,
have you set up master-detail relationships between these tables?

Please give me more detailed descritpion on how you want to add training to each employee.
A
 		Aussie Mick author 3/26/2009

I would like to have a list of table of employees, a table of locations and a table where there are all types of training. I would like to go into the employee record and click add completed training module and select the module from a list. Does that make sense?
Thanks
J
 		Jane 3/27/2009

Mick,
to create dropdown with list of all trainings on the add/edit page of employee table add new field to the employee table where training ID will be stored and set up this field as Lookup wizard on the "Edit as" settings dialog on the Visual Editortab.

To open this dialog doble click on the field.
Also I recommend you to have a look at the How to setup dependent dropdown boxes on Edit/Add pages tutorial here:

http://www.xlinesoft.com/asprunnerpro/tutorial.htm