Different way to enter information ??

[trackmedic]

Question #1

I have a database that tracks training of contract employees. The way we enter the information as of now is to pull up a record on an individual employee and add the type of training into his subform. This updates his record.

With over 100 employees, this coulbe be a very long task. An example would be that 50 employees participated in training "A". I would have to make 50 individual entries. Since our training is limited to 5 classes. I would like to pull up a form on class "A" and enter the employees that took the class. Then I would like that information to transpose onto there records.

Question #2

some of this training expires after a year. I have a report showing that is sorted by type of training and it list the employees who have it. I would like to add a formula that would show if the employee is expired. This formula would get the info from the date the class was taken.


Thanks for the help in advance.


Andre'

 

[Rich]

Use a multi select list box in conjunction with an option group to add mutiple selected records to the table.

=Iif(DateAdd("yyyy",1,[MyDate])>Date(),"Expired", " ")