Do i need two queries (1 Viewer)

[colinmunnelly]

I have a table holding records for a company. I then have another table holding the company address details. I want to create a report showing the record details from a query using a paremeter which is no problem but how do i get the companys details on that report. Hope you understand what i mean

Thanks
col

 

[Fizzio]

Make sure that you have a relationship set up between your Company table and Records Table. As 1 company is likely to have more than one record, set up a 1 to many relationship between the 2 tables using the CompanyID. Then Include the company details in the query that you have described to populate the report. If you are not sure about this, search here or Microsoft.com for 'normalisation'
HTH