Concatenation for one field from two others in same table

Thanks John - Here's a sampling ...

Cust ID Seq Name Address
12CIT4982 000 Citi Bank Bill To Location
12CIT4982 001 Citi Bank Branch Location #1
12CIT4982 002 Citi Bank Branch Location #2

The Customer ID (12CIT4982) is one column of data, Sequence 000 another,
Name another and address another in the .xls export from the DOS system.
--
Dale


"John W. Vinson" wrote:

On Sat, 24 Jan 2009 17:46:01 -0800, Dale
wrote:

If I let Access assign the primary key (1,2,3,4,etc. through an autonumber
choice) then the next time I download from the DOS system(weekly), I won't
maintain integrity because new clients will have been added from DOS - I.E.
what was once 2 might now be 4 so the CRM data entered won't match the right
client.

How is the client information identified in your downloaded file? Could you
post some (real or valid-but-fake) sample data?

If the program is identifying clients by name, does it have some provision for
the case where you might have two clients both named Bob Smith?
--

John W. Vinson [MVP]