>What is the best method for creating a unique id for a record when multiole users are creating records at the same time?
You can have a table, SerialNumber, which stors the next number to be used for each PK or other sequence number.
A UDF, also called SerialNumber, will locate the corresponding record, lock the record briefly, increment it, and return either the old or the new value.
If a table's PK is not visible to the user, just assign your UDF as the default value for the PK field.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
