[AccessD] Combine two tables

My approach for what it's worth.

Select fld1, fld2,fldx,"Table A" as tableSource from TableA
Union 
Select fld1, fld2,fldx,"Table B" as tableSource from TableB

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lembit Soobik
Sent: Saturday, January 19, 2008 10:13 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Combine two tables

Hi, everybody,

In an Access 2002  I have two linked tables,
table A is in the BE which belongs to this FE,
table B is in a different database, and it is used there as well.
Both tables are lists of persons with id, lastname, firstname, and other 
fields.

I want to use names from both tables as customers.
I have made a union query, but this gives me duplicate id numbers.

Is there a way to insert the source table name into the union query,
so that I can then distinguish from which table a certain record is?

Or is there a better solution?

Thank you
Lembit 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com