J
James
I need to build an access database that consists of
individuals holding various level management jobs in
various companies. Then I need to be able to generate a
report that will list the companies alphabetically as well
as under each company, list the people that work for that
company starting with the CEO/President and working on
down to mail room guys. Is there a link to a sample
database that covers this type of organization?
In other words, I need to generate a report like the
following with indentation formatting designating the
organization level (level of supervision so to speak):
Company1
PersonA - Chief Executive Officer
PersonE - President of Finance
PersonJ - Treasurer
PersonF - Senior Accountant
PersonZ- Junior Accountant
PersonB - Payroll
PersonD - MailRoom Guy
PersonX - President of Marketing
PersonK - Marketing Manager
PersonG - Magazine Editor
PersonZ- Adds Salesman
PersonB - Graphic Designer
And so on...
Right now, I have one big table with:
-Key/ID, (interger)
-Person name, (PersonA, PersonB. Person Z)
-Company working for, (Co1, Co2, Co3, Co4, Co5)
-Level Code, (interger - I figured I'd make a field called
Level Code and give the CEO a "1", the vice president
a "2" and so forth on down the line to about "5" or "6"
levels deep)
-Position at that company, (CEO, President, Vice-
President, Manager, Mailroom, etc. by looking at this
field, I would determine what the previous field, the
Level Code number, would be)
-Comments (general comments)
I'm at the design phase right now and need to come up with
a way for users to be able to change a Person's position
at a company (and even change which company he works for)
and have all other people below him shift accordingly
(this to me seems like the worst case scenario, whereas if
a person just got a promotion, not as much data would have
to change). Take the above example: say PersonX's
position is eliminated and the company wants everyone
below him to move under PersonE's supervision. I guess the
user (me) would go to a form, find PersonX, change his
employer from Company1 to any other company, change his
Job Position and Level Code, and then somehow...
somewhere... make it known that the people under PersonX
shift over to be now under PersonE. I guess I could go in
and query all the people below PersonX and change them one
at a time, but I'm getting confused as to the most
efficient way to do this... any thoughts on a smart,
efficient way to do this? Even a link to a help page or
sample database that deals with building organization
level reports from a database would help. thanks so much--
James B.
individuals holding various level management jobs in
various companies. Then I need to be able to generate a
report that will list the companies alphabetically as well
as under each company, list the people that work for that
company starting with the CEO/President and working on
down to mail room guys. Is there a link to a sample
database that covers this type of organization?
In other words, I need to generate a report like the
following with indentation formatting designating the
organization level (level of supervision so to speak):
Company1
PersonA - Chief Executive Officer
PersonE - President of Finance
PersonJ - Treasurer
PersonF - Senior Accountant
PersonZ- Junior Accountant
PersonB - Payroll
PersonD - MailRoom Guy
PersonX - President of Marketing
PersonK - Marketing Manager
PersonG - Magazine Editor
PersonZ- Adds Salesman
PersonB - Graphic Designer
And so on...
Right now, I have one big table with:
-Key/ID, (interger)
-Person name, (PersonA, PersonB. Person Z)
-Company working for, (Co1, Co2, Co3, Co4, Co5)
-Level Code, (interger - I figured I'd make a field called
Level Code and give the CEO a "1", the vice president
a "2" and so forth on down the line to about "5" or "6"
levels deep)
-Position at that company, (CEO, President, Vice-
President, Manager, Mailroom, etc. by looking at this
field, I would determine what the previous field, the
Level Code number, would be)
-Comments (general comments)
I'm at the design phase right now and need to come up with
a way for users to be able to change a Person's position
at a company (and even change which company he works for)
and have all other people below him shift accordingly
(this to me seems like the worst case scenario, whereas if
a person just got a promotion, not as much data would have
to change). Take the above example: say PersonX's
position is eliminated and the company wants everyone
below him to move under PersonE's supervision. I guess the
user (me) would go to a form, find PersonX, change his
employer from Company1 to any other company, change his
Job Position and Level Code, and then somehow...
somewhere... make it known that the people under PersonX
shift over to be now under PersonE. I guess I could go in
and query all the people below PersonX and change them one
at a time, but I'm getting confused as to the most
efficient way to do this... any thoughts on a smart,
efficient way to do this? Even a link to a help page or
sample database that deals with building organization
level reports from a database would help. thanks so much--
James B.