-
Display list of linked customers in a tabbed form
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules