A
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,
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,