I have created a table containing my music collection by importing an Excel Spreadsheet. After a lot of trial and error, almost everything is working fine, however when I create a new record I have to manually enter a number in the ID (Primary key) field. This is a bit of a nuisance as it means I have to determine the ID number of the last record. I have done what has been suggested in another forum, i.e. set the AutoValue for ID to Yes, however all that happens that a zero is placed in the ID field. It was also suggested that I set the Auto-increment statement to IDENTITY, however I don't have that option in Field properties.
I have also typed ALTER TABLE "Table1" ALTER COLUMN "ID" IDENTITY in the SQL window, but without success. Is there any other way I can have the ID automatically insert the next number? -- View this message in context: http://www.nabble.com/Auto-increment-ID-in-a-database-tp16698582p16698582.html Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
