Help on an easy data environment question?

[Shark]

I have two data combo boxes with a data environment.

How do I select from one combo box and have the other combo box populate according to the first combo box.

I know I have to add a command in the data environment, but how do I set up. Do I have to use a child command? What is a child commmand?

Thanks!

[Kersey]

when the first datacomba has been changed (event) refresh/reexecute the query (with a different commandtext(=sql statement)that fills the second datacombo.
hope this helps !

[Shark]

Thanks Kersey!

Is that the only way to do it? I actually need something like picking a certain ID from the first Combo box and the second one will give me a list of products according to the ID I picked.

[Kersey]

there are multiple ways of doing something like this :

Hierachical grids/recordsets is a good way of handling.

but this al depends on what you want on the form on how much data , etc ,etc