Hi Geoff,
Write a function which will generate unique key values (as desired by you) and put this function in the DEFAULT VALUE of the primary key in the table.
By doing this the keys will never be repeated whether you are using BUFFER or not and will not clash with views.
Coming to your question : As user1 will issue a APPEND BLANK a new key will be generated by the function you have written and will be used only with the current record....whether the User1 saves it or not. This will ensure that every user issuing APPEND BLANK will always get a unique key value.
The 2nd part of your question is both the user seeing the same record - which can only happen when the user who created the record in BUFFER mode issues TABLEUPDATE(.t.)
If you are having problems writing the function than let me know i will post this function on UT thread.
Sanjay.
>My main concern is that both see the key and if one attempts to reuse a key by positioning on a record (using indexseek) on a recod that does not actually exist yet.
>
>regards
>Geoff Scott
Sanjay Dhiraj Patel
MCSE, MCDBA
Net2Biz (Thailand)