Combining records from two tables into one row in a query A97

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

Bear with me as i'm not too hot on the technical terms!

I have two tables which i want to link into a query, one
contains company contact details the other properties that
they manage, (one to many?) the problem i have is i can
run a query which displays all the data from the company
contact table but only the first and last property records
on the same line OR i can run a query which lists all the
property records but separately on different lines
repeating all the company contact details.

Ideally want i need to run is a query which puts the
company contact details PLUS the properties (either all in
one column or in seperate columns) all on one line.

Can this be done without me having to get too technical
with modules etc....

Many thanks to whoever answers my plea!

Jo :-)
 
You can do this by assigning each of your managing companies a unique
reference (any format that makes sense to you AB1, Bloggs&co, whatever, and
create a field in your properties table (called managing company, whatever
makes sense) to store the relevant manager.

The relationship between the two tables will then be clear. One managing
company can manage Many properties

You can then easily run an auto query by adding the two tables to the query
grid, select the fields you require from each table.

You can then run an auto report and format it however you want.

The key to databases is to know what you need to get out before you put
anything in!

HTH
Lowland
 
Back
Top