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).
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.
RDH
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.
RDH
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.
No problem .. 
RDH
RDH
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.