Hi everyone. Normally an excel user but i've been asked to put a basic database together for work and got so far but stuck with a query. Any help / pointers would be appreciated. I have put an example of what i am trying to do together but i can't upload (keeps saying invalid file).

I have 2 tables / forms (Employer & Customer). Each customer is allocated and employer which is the link.

I use a navigation form and the employer form is tabbed and i created a query to look at which customer are allocated to an employer. I then dragged this query and created a subform within the tab

It all works apart from it's listing all customer rather than just those attached the the employer, i think i need to set a criteria in the query to match the name of the employer only and report back linked customers.