>I use a udf that stores the pointer, and order. Then sets the order to the primary tag, then goes bottom and increments, then returns order and pointer and returns back new key. Fairly fast udf since it doesn't do any locate etc but if anyone has better code/ideas let me know.
You should use your TABLE.DBF data dictionary table which contains all the tables of the system which, among other fields, contains the actual id key. By having this, you can now establish a lock mecanism which will garantee a unique id in the entire system.