there is an example of that in he tas trade application, look in the database container, it uses the system database. Wes > >Does anyone know how to establish a field in Visual FoxPro database which acts as an AutoID? For example when a user enters a new record this particular field will automatically increment. I know how to do this in MS Access, but not in FoxPro. Can Anyone help? > >Thanks, >Bob