Eoin writes "i want to know whether it is possible to create dynamic primary keys in plain sql. what i am trying to do in my tables is get the max of an integer column in a table, add 1 to it, and let this value be the primary key for my table. i thought i might be able to do it like this: INSERT INTO organisation VALUES(MAX(TelephoneNumber)+1,...etc where telephone number is an integer column. however, apparently its not possible to place a GROUP BY function here. is there another way to do this or should this be taken care of with embedded SQL? thanks"