>>>As a side note instead of append blank
>>>
>>>insert into (lcChild) (quote_no) values (quoteinf.quote_no)
>>
>>What advantages does this have?
>
>The biggest advantage is that you NEVER get a blank record in the table, even for a split second. When many people are adding records simultaneously (or nearly so) the short time between

>append blank
>repl IDField with cNewID

>can allow several people to add records, giving the dreaded 'duplicate file ID' message.


>Barbara

Thanks for that tid-bit. But, this problem of seeing other people's child records in the grid is happening after the unique parent records are created, and the users are appending to the child table.