Re: Combining Recordsets

On Wed, 16 Apr 2008 12:54:04 -0700, Klatuu <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

If all 3 have the same structure and data types, you could use a Union query
to combine them into one, possibly.

You question is a "how do I" question. It would be better if you describe
what you want to do and perhaps we can assist with how to accomplish it.

A good point.

I have 3 M2M relationships with the same master table. I wish to return records from
the master table which fit a minimal search on 0, 1, or 2 entries from the three M2M relationships.
The three link tables all contain a PKey and CKey field. Using these link tables I have
created three recordsets, one from each link table. Each recordset contains the PKey values selected
from that link table.

I want to combine the parent keys (PKey fields) from the 3 recordsets, eliminate duplicates and use the result in a
query on the master table.
.