AutoNumber

[mp3nick]

Hi everybody
how can I make my own autonumber on my basis ? I mean I have MovieID in the table and TotalEpisodeNumber which if I join them together it will be unique, how to order access to join two field in table together to make unique increments integer for me ?

Thanks

 

[splats]

Hello

Instead of creating a new autonumber, you can have both fields be your primary key. In design view, select the two fields MovieID & TotalEpisodeNumber and right click them as your primary keys for the new table. I am not sure if this is what you are looking for, but the result would be that each combination of MovieID and TotalEpisodeNumber would be unique.

For example the combination:
(MovieID) and (TotalEpisodeNumber)
("Footloose&quot and ("original&quot

can only be inserted in the table once as the combination is the primary key.


Another method that you could try is:
create a new table with a copy of the design of the original table (no data to start) and add an autonumber field. then copy your data from the original table over to the new table. The autonumber will automatically fill in as the data is copied over. You can then rename the table and check relationships etc.. This would be more difficult if there are many relationships already existing but it is still possible!

hope that helps