I have a table (TableA) with significant fields Name, CalculationRule and Total. CalculationRule is a set of operations that produces a Total for a specified Worker. The user can create 1..N of these records.
If the totals are populated for a specified worker, it will look something like this:
Worker: Steven
| Name |
CalculationRule |
Total |
| CalcRule1 |
(reference to some calculation) |
35 |
| CalcRule2 |
(reference to some calculation) |
21 |
If the user would like to run the calculations for multiple users the data needs to presented in some appropriate way.
My boss wants it to display in the following way on FormF:
| Worker |
CalcRule1 |
... |
CalcRuleN |
| Steven |
35 |
... |
99 |
| John |
77 |
|
13 |
| Jason |
11 |
|
78 |
I already accomplished this by a bit of a messy way:
- Created a tempTable (TempT) with 25 fields. One is a HcmWorker reference and the rest are Real fields.
- Limit the records in TableA that can be used on FormF to 24.
- Class code to populate TempT from TableA.
- On FormF populate the grid column labels from TableA.Name
This is in working order. I was just wondering if there is (in development terms) a "neater" method? Yes a report would solve the neatness problem, but the user needs to act on the data, which cancels that out as a possible solution.
Thanks for reading
*This post is locked for comments
I have the same question (0)
