>

>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