Hoping someone can help me with this one. I have a cfform
with a cfgrid built in that displays the results of a query that
shows sizes we stock. This works fine and looks great - i do like
However I would like to have a second cfgrid on the same form
that would display the items we have in that size. In my head this
should work by using the selectedItem as the WHERE in the query for
the second cfgrid. I have tried this but it doesn't work.
I think this is probably because I need to update the data
once the item has been selected?
The above may be completely wrong - if someone could
enlighten me it would be much appreciated.
I don't know if this is what you were looking for, but you
can do this quite easily if you don't mind using frames. Just make
the action page of the selection from your first cfgrid the bottom
frame of your page, and then display your second crgrid there.