It would be nice to automate the conversion of an integer in a table to a "serial".
Apparently SQL Server is able to pull this off. The steps required would be to: * automagically create a new sequence * set default value of the desired field to nextval(new sequence) * set the value of the sequence to max(field) As far as GUI is concerned, you'd want the user to be able to select the schema --> table --> field name and the wizard would do the rest. Best regards, Bill Eaton, Ph.D. Senior Engineer AeroAntenna mailto://[EMAIL PROTECTED] tel: (818)993-3842 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster