It looks like you want to update stock with the latest information from the previous date and if you don't have it in agenda, take it from Traiter, e.g.

Traiter
   Stock
   8
Agenda

date             Stock
3/10/07          10
3/11/07          11
3/12/07           5

After your manipulations you want in Agenda

3/10/07          8
3/11/07          10
3/12/07          11

Am I right?

If this is what you want to do, then it should be done using self-join. It's a bit non-trivial, so please confirm first.

Actually, if this is what you want, it's not trivial at all. I think I saw here sample of using some UDF for that.

If you only want to update the most recent information with the prior information, then it's easier.


>>Can you explain what you're trying to do? I cannot make sense of updating Agenda from Agenda.
>
>I want for each day put the stock of medicament.
>
>
>
>AGENDA.DBF
>*--- NAME MEDICAMENT DATE CONSOMMATION STOCK
>Ex : MILCENT bernhart TEMESTA 2.5 14/03/2007 1 50 ( Before )
>MILCENT bernhart TEMESTA 2.5 15/03/2007 1 49 ( Before )
>
>TRAITER.DBF STOCK ( BEGINNING )
>IRESIDENTID 50
>
>
>FOR 14/03/2007 IF NO MEDICAMENT for 13/03/2007 Take stock Of traiter.dbf ...( 50 ).
>
>Am comprehensible?
>
>bernhart
>
>
>