I am using Tracefields for programs, for operators to input 3 bits of information before every program. Work order #, Serial #, and Operator name.
For the Operator Name section, I am wanting to use a drop down menu, with a list of names to select, so that the user will have to select their name instead of having them type it.
What i'm not sure about though, is if I create this list, and use it on every program we use, how can I make this a sort of "universal" list? So as we get new employees and new operators, I can add their name into the list and it will update for all of our programs.
I'm still a bit new to using expressions and VBS, and have not been able to come up with a way to do this.
Yeah, I had the same thought. I have set it up to where I will only have to update the 1 program with the list of names, so that makes it a bit easier. I don't think I will have to edit this very often though in my case, so no big deal... at least until the company grows.
I was able to pull the inputs from my subroutine to the main program, through variables, and then just passed them into new tracefields to use on the report header.
maybe, don't use operator's names, just numbers from 1 to .., make drop down list of numbers, maintain only table with linked numbers to operators, how many operators ?
Appreciate the idea, but I think that would just make things more complicated. The operator name will show up in the report header, for a clear indication of who the part was ran by. currently there are 8 names of operators in the list.