>>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