Create updateable view of Table A innerjoining with Table B then replace the resultset with .T.
>hello!
>
>i use this command to update a logical field in table A which exists in table B.
>
>SELE 1
>USE a
>GO TOP
>SELE 2
>USE b
>GO TOP
>
>SELE 1
>DO WHILE .NOT. EOF()
> SCATTER MEMVAR
> SELE 2
> GO TOP
> LOCATE FOR m.checkno=checkno AND agycode=agycode
> IF FOUND()
> SELE 1
> REPLACE ttype WITH .T.
> ENDIF
> SELE 1
> SKIP
>ENDDO
>
>
>any better way than this?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."