how to create query based 2 combobox?

[siman]

hi guys, i have some problem with my access.


how to create query based 2 combo box
in my case, i have some rule : if the material is vegetable and the process is slice then the tool is knife.
and i have 1 table to connect each primary key, the name is connection.

i already try with this.
SELECT tool.tool_type, material.material, process.process
FROM tool INNER JOIN (material INNER JOIN connection ON material.ID = connection.id_material) ON tool.ID = connection.id_tool
WHERE (((material.material)=[Forms]![Form1]![Combomaterial].[Text]));

its work but the result like that

material	process	tool_type
vegetable	slice	knife
vegetable	mix	mixer

so my problem is i wanna select with 2 variable material and process, the result should be knife not with mixer.

i try with this
SELECT tool.tool_type, material.material, process.process
FROM tool INNER JOIN (proses INNER JOIN (material INNER JOIN connection ON material.ID = connection.id_material) ON proses.ID = connection.proses) ON tool.ID = connection.id_tool
WHERE (((material.material)=[Forms]![Form1]![Combomaterial].[Text] AND (process.process)=[Forms]![Form2]![Comboprocess].[Text] ));

but it doesn't work.
may somebody help me please...
thanks

[orange]

It doesn't work

is not helpful to the reader.

Do any of these apply?
It doesn't work and I get
a) a syntax error message
b) a message with number...
c) the application just stops..... give some context to the reader.

SELECT tool.tool_type, material.material, process.process
FROM tool INNER JOIN (proses INNER JOIN (material INNER JOIN connection ON material.ID = connection.id_material) ON proses.ID = connection.proses) ON tool.ID = connection.id_tool
WHERE (((material.material)=[Forms]![Form1]![Combomaterial].[Text] AND (process.process)=[Forms]![Form2]![Comboprocess].[Text] ));

Are these your names or spelling mistakes?
Good luck.

[siman]

sorry my spelling mistakes. its should be process.

please help me, what i should be to get tool type is knife in case?

i am newbie