>Bernard,
>
>Use a transaction as in;
>
>

>LOCAL llRollBack
>BEGIN TRANSACTION
>
>  IF TableUpdate(2,.F.,"FirstTable")
>      IF TableUpdate(2,.F.,"SecondTable")
>         IF TableUpdate(2,.F.,"ThirdTable")
>         ELSE
>            llRollBack = .T.
>         ENDIF
>      ELSE
>         llRollBack = .T.
>      ENDIF
>   ELSE
>     llRollBack = .T.
>   ENDIF
>
>   IF llRollBack
>      ROLLBACK
>      TableRevert(.T.,"FirstTable")
>      TableRevert(.T.,"SecondTable")
>      TableRevert(.T.,"ThirdTable")
>   ELSE
>      END TRANSACTION
>   ENDIF
>

Jim
Thank you for your help. Most useful.

Just one more..

Can you guide me to some computer based/ CDROM based tutorials/courses in VFP5/6.

We are in Australia and so cannot attend those in the USA. The courses should be for beginner/intermediate/expert levels. I need this for my colleagues who will be taking up VFP.

Thanks

Bernard

My company email is..
bbout@informedsources.com.au