> But my problem is that the leader off the production line want to look at
> how many hours employee have between
> to dates.
> If at the same time the leader off the technical staff want to look at the
> employee he is responsible for.
> 5 sec after lead off prod.line push calc button lead. off tech push calc
> button,
> the end result will be between the to dates which the last leader
> calculated.
This sounds like you're writing the results of these calculations back
to .DBF files. For ad-hoc queries, this is not recommended, precisely
because of the problems that you're having.
Check out the TO CURSOR clause of the SELECT command.
/Paul