11 Replies Latest reply on Oct 20, 2016 2:38 PM by philmodjunk

    Summerise a drop-down field?

    aetherington

      Afternoon all.

       

      I have Table A, and Table B.  Table B has a drop down called status, Table A shows a summary of the statuses.

       

      Table A is related to Table B by StoreLocation.

       

      Currently the values are correct but it uses a really really hacky ExecuteSQL Script that does about 40 calls to get the values.  I am sure this is doable using summary fields instead (The SQL method is just way way to slow)  But nothing I try works, could I get some advise?  Thanks!

       

      Pic below with table a (left) and table b (right)