Hi,

 I need help in setting up the grid with the following specification.

I have a table of routing information, which have Country and State. I also have a details table that holds the Country id, Destination id, and data (i.e. population, growth rate, etc.) corresponding to the selected Country and State information.

My question is, how do I set up a grid which have a column for each Country and State using dropdown lists or combo boxes? When I select a Country, the State list will automatically be updated with states that corresponde to the selected Country. I would like to save the data using the Country and State Id values, not the text values.

Thanks.