>
>select primary
>replace approved with .f. for all encumb_id in ;
> (select encumb_id from secondary where noapp = .f.)
>
Denise,
Try this:
select secondary
set order to noapp
select primary
set relation to approved into secondary
replace all approved with secondary.encumb_id for !eof("secondary")
This should get you what you want the only problem is if
secondary is a view that is buffered you will have to turn off buffering
before creating the index tag.
Hope this helps
Jeff Whitaker