Auto generated table ID?

Hi:

Have checked online help, seems have different approaches for getting an auto generated table ID.

Can you guys let me know: can we create a field which has auto generated number so I can treat that as an unique ID (for example: start from 1000, increment by 1 for each new record, same as MS SQL, or MS Access table).

Thanks.