Hi nadya,

>>Three possibilities come up in mind:
>>1. Use SQL - INSERT
>>2. Use Record or tablebuffering and commit the insert with tableupdate.

>Could you please expand the option 2 here?

See Message #503704

When using record and tablebuffering the record is not validated (Uniqueness viloation or triggers) until the record is commited with tableupdate(). So in this case you can always add a new record with APPEND BLANK, even if a blank PK alread exists.

In my personal framework, the changes people make in a form are (record or table) buffered. The users can commit or rollback the changes anytime.

Walter,