"J" <jk_50@hotmail.com> wrote in message
news:Omd5qdi5DHA.1936@TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm using SQL 7 and I'm trying to automatically assign ID Numbers.
The
> numbers must be in an alphanumeric format using three letters and
> incrementing five numbers.I have two sites where the letters represent the
> site and the numbers represent the visitor. For instance:
>
> Site A Site B
>
> ABC00001 DEF00001
> ABC00002 DEF00002
> etc. etc.
>
> I have a table called Sites and a table called Contacts
>
> Sites Contacts
> Site_ID Contact_ID
> Site_Name Contact_Name
> Site_Address Contact Address
> ... ...
> Site_Code
>
> When we get a contact, I need to automatically assign the Contact_ID to
the
> three letter site code and five digit incrementing number starting with
> 00001
>
> Can anyone help?
>
> Thanks
>
> J
>
>
>
>