Hi Guy's,
I'm trying to build a contact list for the office.
I want to put a filter/query in place.
sample table info:
department team
marketing blue
marketing green
marketing red
HR blue
IT blue
IT green
IT red
On the contact form I have 3 combo boxes department , team , names
The idea is that the user will select the department combo, this will populate the team combo with the corresponding team names and if a team name is chosen then the last combo will populate with the names of the individuals.
Can anyone assist with how i would build a query to do this or a better way? sql maybe?
I think i need something like
select * from team where department = 'value of department combo box'
I am just getting into access and would appreciate it if anyone could point me in the right direction
Thanks in advance...