Different Auto Numbers

[RYAN]

Hello pretty new at this...will try to explain what i
want to do.

I would like to creat a table that has the index key to
be a text/number that I give it..ie. U10001

I would like the table to automatically use the next
number U10002 and so on..

I need to do this because I will have 2 databases in
different trucks that I need to append into one at a shop
location. I am using access97

Can somebody lend me a hand?

Ryan

 

[Tim Ferguson]

I would like the table to automatically use the next
number U10002 and so on..

I need to do this because I will have 2 databases in
different trucks that I need to append into one at a shop
location.

Don't do it! This is called an intelligent key but it's not a very good
name because it is a Bad Thing. First rule says put one piece of
information in one field -- so you should have one field for the "U" (I
assume that other trucks have other code letters -- and a different field
to hold the number. The combination of both must be always unique, but you
can create a two-field Primary Key to ensure that.

Hope that helps


Tim F

 

[eliza]

What exactly is this intelligent key and how do you do that? Cuz' this is the kind of thing I need to do right now. Thanks

 

[Tim Ferguson]

What exactly is this intelligent key and how do you do that? Cuz'
this is the kind of thing I need to do right now. Thanks

My XNews tells me that I am part of this thread, but it must have been from
a long time ago.

I'm afraid you'll have to rephase the question if you want an answer. My
instinct is, however, that an intelligent key is something that nobody
needs to do at any time. You could try reading some stuff on First and
Second Normal Forms.

Best Wishes


Tim F