Thanks for your reply, Fabio,
However, I'm still having some problems. For instance, if I come across a record with a null value present as a result of the child table not having the parents primary index code value, the code is created programatically, by doing a lookup into the parent, appending a new record, and affixing the code to the child.
On doing a requery the first time, the new view does not show any changes. On doing a requery the second time, the code is added, but twice!! This possibly means that the second lookup does not see the code existing, and adds it again during the requery.
My code is as follows:
SELECT vuepkg
SET FILTER TO (ISNULL(nripe) OR ISNULL(ngreen)) AND vuepkg.copr="PKG"
scan
SELECT pkg
APPEND BLANK
REPLACE ncode WITH vuepkg.nCode_a
REPLACE ddate WITH vuepkg.ddate
SELECT vuepkg
endscan
sele vuepkg
requery()
Any help will be greatly appreciated!
Thanks,
Regards,
Steve.