How do you guarantee that two people don't get the same PK?
>Is it possible to get an Identity/PK of a table without adding a record? Here is what I would like to do:
>
>1. Get Identity (next PK number) for a table.
>2. Add a record to a view/cursor.
>3. Once user commands to Save the record, add a row to the table using the PK that was obtained in step 1.
>
>Is it possible?
>
>Thank you.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer