Like many people, it’s difficult for me when I have to expose my ignorance. Permit me to apologize in advance of my question as I suspect the solution is probably pretty basic . . . but I just can’t get my head around it. I would certainly appreciate anyone pointing me in the right direction, and thanks to all in advance of any knowledge. Here’s my task:
I have a functioning database with 2000+ members.
There are multiple (16) units, (companies) that my members may have worked in over time.
Most members have only worked for one unit (company).
A fair number of members have worked in two units (companies).
A very small number of members have worked in three units (companies).
Nobody has worked in more than 3.
Each unit has a director.
The directors want an alpha listing of everyone who has worked in their unit (whether they are still in that unit or not).
So, I need to be able to publish a list for each of the 16 directors.
The fields I am concerned with are as follows:
It probably would have been smarter if I had a separate field for each of the 16 units but I didn’t do it that way . . . so each of the “srvUnitxx” contain the same possible unit ID’s in a dropdown.
What I’m trying to do (I think, unless there is a better way) is to figure out how to read my database into a temporary table three different times (one for each srvUnit) so that I will have everyone in and can then do a sort by srvUnit, then alpha by last then first name.
Gawd I hope this makes sense . . . you can see I’m not very good at this.
Can anyone provide a little guidance or advise if there is a toot anywhere than might be useful?