SQL Server has an auto increment type that is similar to Access's autonumber and Oracle sequences.
1) Open SQL Server Enterprise Manager. 2) Display the table in Design Table. 3) Select the Column you want to assign as AUTONUMBER and change the following column properties: Identity = Yes Identity Seed = 1 Identity Increment = 1 4) Exit and save the table changes.
This sets it up for SQL Server but you still need to let GeoMedia know that the AUTONUMBER (AUTOINCREMENT) is available. For this you need Database Utilities:
Now GeoMedia will recognize the column as autonumber.