Forum Discussion
Help with calculation
Hi, Can someone help me with this? I have three tables: Report, Holes and Recipe. Report: Report Id: 1 2 3 4 5 6 Holes: Hole Id Recipe Id Report Id 1 ...
Every report has holes starting from 0, 1, 2, 3, 4. I want to calculate the preset kg:s / report, into a table.
There can be two different holes, with the same number on one report with different recipes (two different lines per report). We do have one column in the Hole-table, that telss which line we are talking about.
yeah, this is too complex of a data model. Beyond my capabilities, sorry.