[AccessD] Combine two tables

until I know which record belongs to which table, it is.
or better: the duplicate id values point to the need to identify the tables.
now that I have found I need to identify them, (while writing a msg to 
AccessD),
the solution was easy :-)

Helps to send the problem to AccessD, and you get magically a solution. :)
Lembit


----- Original Message ----- 
From: "Susan Harkins" <ssharkins at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, January 19, 2008 4:23 PM
Subject: Re: [AccessD] Combine two tables


> Lembit, the duplicate id values aren't really the problem, right? You need
> to identify the source table -- is this correct?
>
> Susan H.
>
>
>> 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
>
>