Does anyone know how to auto-generate a unique column that
allows me to always have a specific text string in front of
it?
I want to be able to generate unique id's that always start
with the letters "HOT". Therefore, id numbers would be
HOT234, HOT235, etc. I would like the id number column to
be of type text. If so, is there a way to do this in the
table definition screen using an expression so that the
table does it automatically?
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]