Bret, TRANSACT may cause Sarah problems in SQL, but probably not elsewhere. Still, she'd be wise to change it.

About the go RECNO('mytable') - yes, it has to be used carefully - for example it's NOT a good idea to use it after a delete if you have Set Deleted ON - you get weird results. But the SEEK could re-set your pointer in the CHILD table back to the first child record, depending on your indexes.

Barbara

>Since TRANSACTION is a reserved word, do you think it might be dangerous to call a table "transact"?
>
>Do you ever have problems with GO RECNO(something)? I often replace them with SEEK(mykeyvalue).
>
>>Sarah, try adding "go recno('parent')" to your INIT code, after setting the relation between parent and child. Sometimes you have to tell VFP that it's time to activate the relation, and the easiest way is to "move" the record pointer. That's why the relation works after and edit or add.