Hello!
I just recently started learning access, as I do alot of work with it on my new job. Currently I'm trying to create a specific database but having some issues. Mind you, I've only been using access for about a week so I'm pretty green still.
Basically what I want to do is have a series of Command Buttons near the left part of my form, when clicked on display unique information in a list box along the right side of the form. From there, I want to click on the options in the list to fill in a series of fields along the bottom part of the form. I made a diagram to better explain what I'm talking about.
So basically I have Command Buttons on the left for each Department. I have a separate table made for each Department. So Department One has a specific table made for it that has Person 1, 2, 3, 4, 5 for example. And Department 2 has its own table that has Person 6, 7, 8, 9, 10, etc. What I want is to have it so when I click on the Department 1 Button, the List Box to the right shows a list of everybody from Department 1. Or when I click on Department 2, it shows everyone in Department 2, etc etc.
Then, what I want is to click on a person within that list, to show additional information about that specific person in the fields at the bottom.
How I have it setup table wise is that I have a Master Table that has everybody in it, all with the additional information such as Last Name, Email, ID, Title, etc etc. Then I have smaller tables for each individual Department connected to the Master Table with a relationship. So kinda like this...
Department One Table
[Auto-number Primary Key Field] [First Name]
- Person 1
- Person 2
- Person 3
- Person 4
- Person 5
Department Two Table
[Auto-number Primary Key Field] [First Name]
- Person 6
- Person 7
- Person 8
- Person 9
- Person 10
Master Table
[Auto-number Primary Key Field] [First Name] [Last Name] [Title] [ID] [Email]
- Person 1
- Person 2
- Person 3
- Person 4
- Person 5
- Person 6
- Person 7
- Person 8
- Person 9
- Person 10
Make sense? Anyway, any help would be much appreciated. I'm basically looking for some advice on how to best do this.