Auto Number

[aubrey]

Good Afternoon All,

I have an auto number field in several liked tables, I need that auto number
format to be unique in each table; I have read a lot of the posts on this
subject and they involve a lot of complicated codes, which I am not good at.

My approach to solve this problem was to put and "A" in the Format field in
the table of the first database a "B" in the second database, so on and so
forth; this would give me results such as A1. B1. so that when I combine
these records in my master table they still have unique values.

I just need to know if this will work in the long run or if there is a
simple way of doing this. Any help would be greatly appreciated.

Thank you,

 

[Jerry Whittle]

It won't work as Access won't all you to append characters in an autonumber
field. If you just want it to be formatted with an A, B, etc, that would also
be a problem as formatting is what you see and not what is actually stored.
In other words an A55 in one table could be the same as B55 in another table.

You could upgrade to SQL Server which has a GUID's (Global Unique
Identifier) data type. It will create unique primary keys across all tables.

 

[Guest]

Good Afternoon All,

I have an auto number field in several liked tables, I need that auto
number
format to be unique in each table; I have read a lot of the posts on this
subject and they involve a lot of complicated codes, which I am not good
at.

My approach to solve this problem was to put and "A" in the Format field
in
the table of the first database a "B" in the second database, so on and so
forth; this would give me results such as A1. B1. so that when I combine
these records in my master table they still have unique values.

I just need to know if this will work in the long run or if there is a
simple way of doing this. Any help would be greatly appreciated.

Thank you,

 

[John W. Vinson]

Good Afternoon All,

I have an auto number field in several liked tables, I need that auto number
format to be unique in each table; I have read a lot of the posts on this
subject and they involve a lot of complicated codes, which I am not good at.

My approach to solve this problem was to put and "A" in the Format field in
the table of the first database a "B" in the second database, so on and so
forth; this would give me results such as A1. B1. so that when I combine
these records in my master table they still have unique values.

I just need to know if this will work in the long run or if there is a
simple way of doing this. Any help would be greatly appreciated.

Thank you,

I think you're on the wrong track.

Autonumbers have NO MEANING and their value cannot be controlled or edited.
They should generally not be visible to users, *at all*.

What is the "master table", and what are these linked tables? How are they
related? I think your table design needs to be reconsidered, if you're trying
to assign meaning to autonumbers in this way!