>Denise,
>
>You're so close! :) You need to use the SQL delete command, not the traditional VFP delete. To do this, just use WHERE instead of FOR:
>
>delete WHERE item_id in (select item_id from OtherTable)
I knew there had to be a way for sql to save me!! Thanks!!!!
~~~~~~~~~~
Denise
~~~~~~~~~~