lifeson
08-01-2007, 07:51 AM
Not sure if the thread title describes what I want to do but here goes:
I have a workbook with 3 sheets:
Data - this conmtains all the unique data about employees eg, pay no, first, surname addresss etc
Course - this contains details about a specific training course and type
EmpCourse, this shows a list of employee payno and the course they attended on which date
What I want to do is on a form when a particular course is selected, t shows the unique details about that course (done that :clap: ) but I also want it to show a list of all the people who have attended that course.
I can get it to list the pay numbers of the people but I also want it to look up the name (column B) based on the pay number from the data table
I also need to be able to export a list of the paynumbers shown in the results list and create a new sheet with their names and addresses to use as a mailing list
Any help greatly appreciated.
I have a workbook with 3 sheets:
Data - this conmtains all the unique data about employees eg, pay no, first, surname addresss etc
Course - this contains details about a specific training course and type
EmpCourse, this shows a list of employee payno and the course they attended on which date
What I want to do is on a form when a particular course is selected, t shows the unique details about that course (done that :clap: ) but I also want it to show a list of all the people who have attended that course.
I can get it to list the pay numbers of the people but I also want it to look up the name (column B) based on the pay number from the data table
I also need to be able to export a list of the paynumbers shown in the results list and create a new sheet with their names and addresses to use as a mailing list
Any help greatly appreciated.