How do you autoincrement a unique id in a foxpro database? I am using coldfusion and a foxpro table. The table has two columns: LicenseId and Licensee. I want to add a new license to the licensee column and have the license ID in the licenseID column autoincrement to the next number.