hey Luddite Lad , i see u r really good , anyway thanks for trying but it's not exactly the direction i am heading to let me try and explain it a little more ..
we have about 42 persons in my department as i mentioned before i work in the airline industry and my department we import and export cargo ...
We have about twelve different job functions for example we have import cashiers , export cahiers , telephone agents,manifesting agent , palletizing agent and others , now each employee has a title in my department u can only be a Cargo Agent , a Supervisor or the Manager.. Now because the work can become monotonous each employee is rotated every three months or so to work the various functions, whenever an employee is going to be rotated to work a new function for the first time , he/she has to get training in the area for about two weeks,also because we handle cargo each staff has to undergo certain training once a year to handle Dangerous goods and stuff like that....i hope u r keeping up with me , Also each employee is assigned an ID number for example my number would be say "7847" , so that's basically y i am trying to create this database because it will keep track of each training that a particular employee has done and the date in which he started the training and for example if it's training to handle dangerous goods then it would show when that training should be renewed since it has to be done annually, so what i am trying to do is create a form where all the employees data like first name , last name, id number, title can be entered and also a form where each function that the employee has completed can be entered like the function in which they did the traing and the date of the training can be entered but i want to set it up in a way that when u r viewing a specific employee data u can click on a button to add the function that that employee is going to start training in and the date of the training and the date of the next training , i hope i am not comfusing you..
post back a reply and tell me if u understand what i am trying to do here please
thanks for your help so far