On Jun 11, 8:21*pm, Wile Coyote wrote:
I know this is not a project group but the project group seems to have
gone over the rainbow. *If anyone can please help me out with this issue
I am using Project 2007 and I have a dilemma with the way my task are set
up. *
In gantt chart view *entry table selected *i created a "job #" custom
field. *That all works great.
When I switch over to resource Usage view, with Usage table selected, I
cannot link to the custom field on the task side. *
I tried using WBS and I have several projects consolidated so my
numbering system with WBS did not work at all with the consolidated
projects
I tried using another custom field on the resource side and use a formula
to retrieve the job # field but to no avail. *I believe that would be
possible if i knew the table naming scheme and the query naming scheme. *
It seems like this software is much like Access database so it seems
there should be some way to accomplish this task.
I know I can enter the job number on every "task name" record but i copy
paste most of these from excel spreadsheets generated from other
software. *the job number is always going to be in a different field.
That would be very inefficient
The reason I need this is we run several "jobs" at the same time and
several of the operations have the same task name. *So when I view the
resource usage, *my "welder 1" resource may have 50 tasks and 20 of them
may be named "weld mounting bracket" *Since all the mounting brackets are
job specific he MUST know which job number that task is associated with, *
i.e. *"#8625 weld mounting bracket"
Please post or email a solution or suggestion or let me know if what I am
trying to accomplish is just impossible so I will at least know to quit
wasting my time. *My Email is:
Thank You
JS
PS: *if I don't see a response fairly soon I am going to cross post this
into an Access NG and an Excel NG as they seem to have much more activity
Please, I need this badly so i hope no one is offended.
Try posting here (as this is where PROJECT issues get logged):-
http://answers.microsoft.com/en-us/o...&page=1&tab=no