thanks for the input.

i think i will need to stick with GUIDs because i am porting this from
a VB application which uses GUIDs. i dont think my client will have it
any other way.

can anyone recommend a robust GUID generating UDF thats pre made?

many thanks