>> I have to do this calculation, because the raw data is just times when the
>> emp. enter work and leave work.
>
I thank you all for your replays, I thing my situation is a bit more complicated at that.
First my raw data is not mine.
The table look like this
Emp. date1 hour1 date2 hour2 dep job
N6 D8 N6 D8 N6 N6 N6

Emp. use barcode cards to enter work,but sometimes they punch wrong dep and even job.
From this raw data I calculate how many hour the employee has been at work.
Every emp. has his personal workhours.
Some start at 7 some at 7:30 some at 8 and so on.
Some is working first shift some the second.
So each week they are making a scheduler telling the system which emp. is working from 07:00 to 15:00 and who is working
from 15:30 to 23:30.
This info is needed for me to calculate payed overtime. If a worker is on shift 2 and is working from 9 to 11 he is to have
2 hour 50% payed ot.
If his workhour ends at 15:00 and he is asked to finish some work and he leavs 15:30 then for this additional half hour
he is payed 100% overtime and so on.
How he is payed is in his personal workhour sched.
There are some other calculation to before the stage one result.

Now the leader off the shift have to acknowlegde every emp. working overtime.
The emp. is payed regarding how many kilo fish they are able to cut. How big the yield is, and the size off the fishfilet.
Here I just get raw data to. The emp. average hour payed is calculated for the hole week.
If something happend with the weight system or other malfunctions happend the emp. get
some hour marked as "not hour to calculate your result from" Then in the end when the average hour payed is
calculated this hours are payed with the weeks average hourpay.

All this means that the different people responsible for their department have to adjust hour, withdraw hour.
Because the end calc. result always is the same I made some corrections dbfs.

I have also made several quality control system, If an emp. have punched wrong job, and he have kilo on another job
warnings are given that he is missing kilo on the job.

My problem is that I use a lot of views because I find them convinient to use.

They are easy to index and with 200 emp. to keep track on, some off them are changing dep and job several times during
a workday it is easy to sort and so on.

I have not seen the power off cursors in the same way they are read only, and from my exp. cursor are writing over other cursors
in workarea.

So my calculated end result is tables and views in forms to this tables.

My problem is multi user related.

Is there a good way to solve this???

Best regards
Per Simmersholm