2 Replies Latest reply on May 9, 2006 7:27 AM by Iceborer

    Linking cfgrids

    peterdoyle Level 1
      Hi,

      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.

      Cheers
      Peter