Can anyone help me with the following issue. I have an Allocation process that contains a Count Status box currently set up as a global field that looks like this
Behind the scenes are the following controls and scripts to populate the Count Status box within this layout
Script "Update_Status_US-CAN" -
Set Field [Allocation US CAN::CountStatus;
ExecuteSQL ("Select Status,
FROM \"Allocation US CAN\"
GROUP BY Status "; ": "; "" ;
Allocation US CAN::BurstLevel_Selected_g)]
Exit Script [Text Result:True]
This is running fine and giving me the Allocated and Unallocated Counts as I allocate the Codes - however the sales team would like to see this information presented in list form as shown below
Freq 166.380 Burst 10.1 Count Status Allocated 516
Freq 166.380 Burst 10.3 Count Status Allocated 490
Freq 166.380 Burst 10.7 Count Status Allocated 498
so that the availabilty in and around a specific Burst is visible to aid selection.
I have tried to create a list but believe that the Count Status being a field created as I allocate, it is not stamping this information anywhere so that I can present it in another layout. As I change the Freq and Burst on the Allocation table so the list changes to reflect the current Count Status.
Hope that this makes sense