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 #
503704When 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,