primary key - user entered/auto increment

I am starting to design a database in sql, to replace a flat file db. The database holds records, currenlty there is a new database for each record, so each record for each project starts with a id and increments. I want to create a sql database that will hold all records for all projects, so

Re: primary key - user entered/auto increment

David Johnston [EMAIL PROTECTED] wrote: I am starting to design a database in sql, to replace a flat file db. The database holds records, currenlty there is a new database for each record, so each record for each project starts with a id and increments. I want to create a sql database