>Hi, Can anyone help on how can I create auto generate user ID on the Form Generator??
Basic way to create unique ID:
1. Have a table 'Counters' with 2 fields: tablename,counter.
2. Write procedure 'CreateId' accepting Tablename parameter.
3. Call this procedure: locate record in Counter (by Tablename), lock this record, take counter as new Id, increment counter, unlock record, return new Id.
Edward Pikman
Independent Consultant