combining queries

[Toeying]

Hello All,
I am wondering is it at all possible to combine results from different queries to display them in one control like a list box.? All the records will be linked by an Address ID but they reside in different table e.g mum, child, carer all with the same AddressId. I want to run a query to list all records at a particular address with a click of a button. I have been able to get the mum records at each address, but I dont know how to combine that of the child and carer so that they show up too!! please help.
Many thanks.

 

[namliam]

Sounds more like a design issue, having the same data in different tables.... not good...

You could try using a UNION query, howevever that will result in a display only -non-editable- recordset.

Select x,y,z from table1
UNION ALL Select x,y,z from table2
UNION ALL Select x,y,z from table3
You can repeat this as much as you like also add a where and what ever you want in the selects.