Hi,
Yes i am from Norway.
Ok, so far so good, but the big problems seems to be, the conection of info.
Because i can't see to get the personel, at work and task to work togeter.
The output should be like this.
Name, 06-07, 07-09, 09-11
Hanne Arm2, Arm4, Taste,
Randi Arm4, Arm2, Face
And so on
I can't see to get this right.
...
JobRotation
Last Activity: Jul 1 '08, 06:26 PM
Joined: Jun 28 '08
Location:
-
Jobrotation, check out
I found out after using following code.
I have put out the database so fare...Code:SELECT Navn, Int((14-1+1)*Rnd()+1) AS Random FROM Personell ORDER BY Int((14-1+1)*Rnd()+1);
Leave a comment:
-
Thnx alot,
Got the query, on randomize the people working.
Now i am realy stuck on the exckusion list.
I have set up a table on, People at work, then i have made a table Peoplework_id and true/false on each taskallowed.
The second real problem is to get it to show 14 people at work doing 14 diffrent task which they are qualified to do.
Would be greatful for help....Leave a comment:
-
Job rotation list based on qualification
Hi, i am working on a database, which are making job rotation on factory on diffrent task.
We have 25 people totaly at work
14 of them are working at the same time on 14 diffrent tasks.
Not all can do all 14 jobs/tasks.
Any ideas on how to make a randomized list, which exludes some tasks for the people who can not do the tasks.
Greatfull for all ideas and responses
No activity results to display
Leave a comment: