Concatenate a primary key!?

  • Thread starter Niklas Östergren
  • 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
 
N

Niklas Östergren

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top