Automatic numbering of members with a letter

[Céline Brien]

Hi everybody,
Already have a DB with members in Office 1.
We are opening a new office. Office 2 will have it's own DB.
Using link tables and union queries, the members of Office 1 and Office 2
find themselves in the same list.
To tell apart members of Office 1 from members of Office 2, in the DB of
Office 2 I create a autonumber field with the following format : \A00000
Everything looks fine, BUT, when I put the two list together with a Union
Query, the letter A goes away. I can't tell apart members from Office 1 to
members from Office 2.
What should I do ?
Your help will be greatly appreciate,
Céline

 

[KARL DEWEY]

Use a field named Office. Put 1 or 2 in the field.

 

[Céline Brien]

Hi everybody,
Hi Karl,
Thank you for your answer.
That is a wonderful suggestion.
I will use Office P and Office A
Whenever necessary, I wil put the two fields together and obtain the letter
and the number.
=NoMember:[Office]&" "&[MemberNo] and obtain :
P1
A1
P2
A2
etc.
Thank you so much for that idea.
Very simple to implement.
Céline