adding field as unique to a table
there are five fields in a table and i want to introduce a field index in the table which will be primary key and will uniquely identify a record and it will go on incrementing as and when the recoed is added to the table...
earlier fields of table are
ship_to all these three are primary keys
now i am having problem with updating the database with primary key so will introduce a new field as index and go on adding it so it wil uniquely identify a single record
but my problme is how to incement the index when user enters a entry in the table maintiances screen and save it....
please suggest how to do it....
i want to use a unique field index and it goes on adding as user enters the data and this index to be inserted in the table