I have recently swapped the back end of a database from the access .mdb to a Teradata table. I'm running into a problem with this seeing as Teradata does not offer an autonumber data type. Is there anyway I can use something as a substitute? My current column for the autonumber is the RequestID I've tried creating a field on the form for this id and doing something like RequestID = RequestID + 1 (and the likes) with no success.
Any ideas would be GREATLY appreciated!
Thanks in advance!