Search results

I'm not sure I am following. The state lookup table has fields StateName (text), State (text), CL (Y/N) and WC (Y/N). StateName includes the individual states plus the group names All CL and All WC. In the combo box on the main form, if All CL is selected, I want the State field for all...

I have a combo box on a form that uses a lookup table for the value. The value can be a single state or a predefined group of states. If I choose a value that represents a group of states (the lookup table has yes/no columns for the group level), how do I get the individual states for that group...