Interpreter/language problem

[boo]

Hi

I am setting up a database of interpreters. At the moment the tbl_Interpreter contains interpreter name, address, etc as well as 80 or so records for each language, ie tbl_Interpreter.French with a yes/no data type. I want to design a form with a check box or drop down list to allow the language to be selected. This will then be passed to the query. My problem is how do I get the result, i.e. French from the dropdown box into my query? The structure in SQL is something like

Select Interpreter Ref, Name
From tbl_Interpreter
Where tbl_Interpreter.Language = True

So how do I insert the result from the form into the .Language part of this?

I hope this makes sense! Any help would be most greatly appreciated.

Cheers.

[June7]

You have a table with a Yes/No column for each language? This is not normalized data structure and trying to create this sort of dynamic conditional criteria in an Access query object is probably not possible. It could be done in a VBA coded recordset but I am guessing that is not what you are doing.

Normalized data structure which allows association of multiple languages for each interpreter would be:

tblInterpreters
InterpreterID (primary key)
InterpreterFirstName
InterpreterLastName

tblInterpreterLanquages
InterpreterID (foreign key)
Language
ProficiencyLevel (speakonly, readwrite, all)

Now the query can have a criteria parameter for the Language field. This parameter can be reference to the form combobox.

[boo]

Thanks very much june7. I will redesign my table structure and try that out.

Cheers