[AccessD] Combine two tables

thanks Jack or Pat, that works

Lembit

----- Original Message ----- 
From: "Jack and Pat" <drawbridgej at sympatico.ca>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Saturday, January 19, 2008 5:27 PM
Subject: Re: [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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.7/1232 - Release Date: 
> 18.01.2008 19:32
>
>