Concatenate a primary key!?

  • Thread starter Thread starter Niklas Östergren
  • Start date Start date
N

Niklas Östergren

Hi!

I have 2 tabels in a UNION query (tblPerson & tblNewMemberShipEntry). Both
tabels have a primary key [PersonID] & [NewMemberShipEntryID].

Since both primary key fields start at 1 with the first entered record there
is likely that I will have records with same primary key. Therefore I´d like
to add some signs to the primary key in tabel < tblNewMemberShipEntry >.
Like this:

1A
2A
3A

Instead of:

1
2
3

Is this possible? And how do I do, if so?

TIA!

// Niklas
 
Hmm, forget it!

I did add a sign letter "A" after the primary key for tblNewMemberShipEntry
in my UNION query. Now I just have to use Trim-function to get the correct
primary key for these records.

I don´t know if this is the best (easyest) way but I hope it´s going to work
anyway!

// Niklas
 
Back
Top