Querry from a multivalue list

[TOMMY.MYERS668]

Ok, I have two forms for now, one is certified instructors, the other is msr entry. I'm trying to make a combo box only show the instructors certified to teach the class. So when the actual course is selected I want it to run a query like:
Select full name
From certified instructors
Where certified in contains forms.msr entry course , the problem is some instructors can teach more than one class. In fact most can. I get an error that I cant use a multi valued field with a where clause.... Any ideas ive had a few months break so I am access stupid until I get back into it gor a while.

[ssanfu]

I don't use multi-value fields. I don't know of any good programmers that use them.
IMO, it breaks the rules of normalization. It also makes it harder to up size to SQL SErver/Express or another major dB.

You might look at this site: http://office.microsoft.com/en-us/ac...010149297.aspx


I googled "multi value field access 2007"

[TOMMY.MYERS668]

Yeah found that one allready.. Its actually in the built in help.. It should be something to do with cascading combo boxes but I can't get them to link together correctly.

[ssanfu]

Do you want to post your dB with a few records for analysis?

[TOMMY.MYERS668]

Yes but im on my phone all day... Will be home in a bit

[TOMMY.MYERS668]

ok back to this mess--- I took out the multi valued fields and made yes/no fields for all the classes on the instructor certifications form -- so no i need the msr entry form to have a combo box to show me all the instructors certified to teach [course] -- i cant seem to figure out how to make the cascading combo box thing work -- my screen looks different than the video ive watched 20 times allready.. i can post the db here but do I need to zip it first?

[ssanfu]

Probably compact and repair, then zip it.