I have a parent table of insurance companies and a child table of all the different policies the companies offer. I want to place 2 combo boxes on a form, one allowing the user to select a company the other allowing the user to select a plan.

Id like to have the second box limited to the choices that relate to the insurance company selected in the first box, but I dont really want to write query and base the second box on it because the form already has a very complicated data environment.

Is there a way I can base the second box on some kind of sql statement taking into account the first box's value?





TIA
CHRIS