>Colin - I didn't mention that in my original post but what I do to avoid moving the pojnter at all is as follows
>
>
>lcoldalias = ALIAS()
>USE polines AGAIN IN 0 ALIAS countlines
>SELECT countlines
>
>COUNT FOR countlines.idnumber = thisform.idnumber.value TO lnreccount
>SELECT (lcoldalias)
>USE IN countlines
>
>IF lnreccount = 0
> *** Insert stuff here
>ENDIF
>
>*** Refreshes and so on
>
>
>I am copying this to Erik. HTH
Nice, but since the tables are buffered, allowing deletes on the child records throws a wrench into this. If my child table has 1 record that I delete and I haven't issued TABLEUPDATE then the COUNT on the USE AGAIN.... will return 1.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.