AnsweredAssumed Answered

Summerise a drop-down field?

Question asked by aetherington on Oct 20, 2016
Latest reply on Oct 20, 2016 by philmodjunk

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)

 

Outcomes