I need urgent help with an Access 2003 recordset question. I have a table of employee position information that indicates the position number of their manager. I need to loop through and create a roster list.
The relevant table/field information is:
Table: tbl_position
Fields: position_id, employee_name, reports_to_position_id
I was thinking of having the user enter the position id of the roster they need, adding that position id to a recordset, then pulling all records that 'report to' that position. Add the first match, loop through for their employees. So on and so forth.
I think I can fugure out all of the looping and finding of positions but I'm drawing a blank on how to add records to a recordset one at a time when I don't want to update ANY information. This is for display/export only and will be in a multi-user environment.
The roster could be many levels deep:
Senior VP #1
VP #1
Director #1
Manager #1
Sales Rep #1
VP # 2
etc....
Once created I'll bind a form to the recordset to allow viewing/filtering/exportin
g.
Any thoughts?
Start Free Trial
