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)