Sep 14 2006, 08:51 PM
my unique key is a combination of text and a number (e.g. AA123) what would i do in order for it to become continuous (e.g. AA123 and become AA124 in my next record).
Sep 14 2006, 08:56 PM
The Primary Key value should not have any meaning to you or your user ...
You should instead use an Autonumber for your Primary Key for the table ...
You can have this field combination in your database as a composite index if you like, but it should not be a composite Primary Key.
Sep 14 2006, 09:07 PM
Sep 14 2006, 09:22 PM
Do a seach on UA on DMAX to find ways to increment the code you want to use. But, as Ricky said it shouldn't be the PK.
Sep 14 2006, 09:30 PM
No problem ..
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here