Hi all!

I'm using VFP 5.0 and have a screwy view I'm fighting with.

My view is the result of joining two tables, a "master" containing the bulk of the data I need and "lookup" from which I need to get a display value for a code in the "master".

I've been tinkering with adding and deleting records from the view and then back to my original tables on a form I'm working on.

My problem is that my view is displaying a record I deleted from my "master" table. The mystery record has been deleted from my "master" table, but when I do

REQUERY('myview')

the mystery record keeps showing up in my view.

Any clues where I should look to resolve this??

MTIA,
Mandy