Display Multiple BE Table Results

[on-2]

I have 3 identical fe be database running each with a table called cars that has identical form values just obviously different data. I want to create a table or query to display all the results from these but whenever i try and make a query i cannot seem to work it out. Anyone got any ideas?

 

[Pat Hartman]

You need to have one database where you link the tables from the three backends. Then you can create a union query to get data from the three linked tables into a single record set you can use as the RecordSource for a report.

 

[on-2]

u r a star

u r a star as always thank you