Connecting Combo Boxes

[jeo]

I have a combo box on one form where a person picks a department. On the next form there is a combo box with all the tasks that all departments can do (training, programming, customer service, etc).
I want to tie each department to each specific set of tasks so when a user clicks on a certain department the next form will open only with specific tasks for that department. Is this possible at all? Is this something that I have to do in a relationship environment or on the forms?
Thanks.

 

[KenHigg]

Sounds like you need a dept -> task table. Then in combo 2, set it's row source to a query which has combo 1 as a criteira.

Is this over simplifing your situation?

???
ken

 

[jeo]

I understand I need a new Department/Task Table.
Do I need a primary key here or do I create relationships from this table with tblDepartment and tblTasks?
This this is a little unclear: "Then in combo 2, set it's row source to a query which has combo 1 as a criteira."
Could you explain in a little bit more detail?
Sorry and thank you!

 

[jeo]

I've been at it all day...
Still no luck. I just can't figure out exactly how to create, what query.
I've been basing my query on the Department/Task table, but then how do I do I set my comobo1 to be a criteria in that same query?
Did I misunderstand KenHigg?
Any help would be appreciated.
Thanks.

 

[KenHigg]

Sorry for the delay....

Can you post your table structures. I was wondering if you already have 'tasks' defined in another table...

kh

 

[jeo]

Here is the table structure...
Thank you!

 

[aleb]

Here try this

 

[jeo]

Spasibo!
I think everything works, i just have some duplicate records I need to look into.