I am a novice at this, but I tackled the same problem with a listbox, and dropdownboxes and listboxed dont differ that much.
This is what I did.
when the state is selected, create a dataview that filters on the state.
bind that dataview to your dropdownbox and voila (as the french say)
If you want me to cite the code, just reply, I will be home tonight, and able to do so.
vincent
I presume you have a filled dataset operational and working. If not, basic steps for creating such are :
create connection
create adapters (one per table) that use the connection
create dataset
fill dataset tables with the data, using the adapters
(this is a possible generic way of creating dataaccess)