>>>>>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
Ok, it set it, so it's Ok. However, if for some reason you lost the record, note that you generated/inserted primary key value, so you can alway double-check by SEEK newprimarykeyvalue
Edward Pikman
Independent Consultant