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
the cfgrid.
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.
WHERE DIMENSIONS="{stock.selectedItem.SIZE_OR_DIMENSIONS}"
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.
Peter, you didn't indicate what type of CFFORM you're using,
but if it is a Flash-style form, you might take a look at something
from the helpful folks at the
ASFusion
blog
2
Replies
AdChoices