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...