Hi,
This is probably a really easy question but i cant seem to find an answer anywhere.
I've got a datagrid in which the first 2 columns are comboboxes.
I have them populating from 2 different datasets but what i need is for the second one to be filtered, depending on what is selected in the first.

How is the best way to pass the selected value from the first combo to the query in the second?

On a related note, how can i set the combos to values i pull back from a query?
Basically I'm running a query to pull back a load of information that has been previously entered and then populate the grid so that it can be viewed/amended, but i cant seem to set the value (or the display value) to what i pull back, even when it appears in the list of options in the drop down.

Hoping you can help

Thanks

Gimbal