>>>>I tried to reply earlier but as you know the system has been down.
>>>>
>>>>I tried using Insert-SQL and it did insert a new record but still would not insert the parent.key_id (using the value command/arguement).
>>>>
>>>>--lincoln
>>>
>>>You should collect key from parent table or generate new value in a case of new parent record. This value will be used in INSERT...VALUES()
>>
>>If you use INSERT, will the record pointer of the grid change automatically to the inserted record? If not, how do you know the Recno(), especially in multi-user-environment (There could be a new record after your's)
>
>Insert will set pointer to new record.
>Why should i know the recno()? If new record will be added by another user, it will get new recno() automatically, what's problem you see here?

If the pointer is set to the appended record, indeed there's no need to know the recno(). But if not, I wanted it to GOTO (newrecno()).

Thanks,

Angelika Lautz