UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Primary Key is continuous with a combination of text and number    
 
   
andrewpogi
post Sep 14 2006, 08:51 PM
Post #1

UtterAccess Member
Posts: 30
From: Cebu, Philippines
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).
Go to the top of the page
 
+
R. Hicks
post Sep 14 2006, 08:56 PM
Post #2

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
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
Go to the top of the page
 
+
andrewpogi
post Sep 14 2006, 09:07 PM
Post #3

UtterAccess Member
Posts: 30
From: Cebu, Philippines
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thanks.gif)
Go to the top of the page
 
+
ScottGem
post Sep 14 2006, 09:22 PM
Post #4

UtterAccess VIP / UA Clown
Posts: 25,072
From: LI, NY
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.
Go to the top of the page
 
+
R. Hicks
post Sep 14 2006, 09:30 PM
Post #5

UA Forum Administrator
Posts: 38,073
From: Birmingham, Alabama USA
No problem .. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

RDH
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 08:30 AM