Display all records for one business in one form?

[AWilderbeast]

Hi dont know how im gonna explain this but here goes,

I have a table of businesses and each business has vacancies and consultancy time under it through related tables, so i have

Businesses
|
------------------
|.......................|
Vacancies........Consultancy​

I want to be able to display all the Vacancies for one company in a form and all the consultancy in one form, i know i could do it though querys but i have 600 companies and that would be ridiculous.

Is there any way i can do it by selecting a business and been able to see all records for that business.

Thanks for your help

 

[neileg]

You're asking a lot of related questions.

My answer here http://www.access-programmers.co.uk/forums/showthread.php?p=423958#post423958 is relevant to this question.

 

[AWilderbeast]

Like this is, you know how?

If you have a look at the attached picture that is a screenshot of what im after, you can see a list of vacancys with company names next to them and they where collected from 2 tables and when you press view it opens the vacancy details up. and id like the same for the consultancy

Anyone know how