>>>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?
Edward Pikman
Independent Consultant