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
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