Union Queries

[helpneeded]

I have joined to identical tables with a union query, the problem is, that when I use this query in the relationship window i lose my primary key references. Is it possible to create the keys as part of the SQL select statement.

Thanks in advance for your help [sig][/sig]

 

[jagilman]

I am not sure but I think Access might have a problem with the key field name being the same. &quot;Ambiguous?&quot; Check out this word in Access help. You may need to create an &quot;Alias&quot; for the linking field name in your query. [sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]