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  && This is the child table which has no matching code ...
APPEND BLANK
REPLACE ncode WITH vuepkg.nCode_a &&This is the code that is missing, but; present in the view, through the parent table
REPLACE ddate WITH vuepkg.ddate
SELECT vuepkg
endscan
sele vuepkg
requery()

Any help will be greatly appreciated!

Thanks,

Regards,

Steve.