joshblevins
Member
I have two tables.
1. Unit Hour Utilization.
2. Run Counts
In table 1 I have a column for total hours (this is a calc element so it does not save to the database)
Table example
ID DATE UNIT Total Hour
1 1-1-2015 401 24
2 1-1-2015 6 24
3 1-2-2015 401 16
In table 2 I have a field for Total Hours Unit hours for the day. Which would need to calculate the total unit hours for the date selected from table unit hour utilization.
Result Example
If I select date 1-1-2015 on my form I would need the Total Hours element on Run Counts form to produce the number 48 (the total amount of unit hours on 1-1-2015)
I am a bit lost on which type of element to use to do this and not sure how exactly to go about coding the query in fabrikar.
1. Unit Hour Utilization.
2. Run Counts
In table 1 I have a column for total hours (this is a calc element so it does not save to the database)
Table example
ID DATE UNIT Total Hour
1 1-1-2015 401 24
2 1-1-2015 6 24
3 1-2-2015 401 16
In table 2 I have a field for Total Hours Unit hours for the day. Which would need to calculate the total unit hours for the date selected from table unit hour utilization.
Result Example
If I select date 1-1-2015 on my form I would need the Total Hours element on Run Counts form to produce the number 48 (the total amount of unit hours on 1-1-2015)
I am a bit lost on which type of element to use to do this and not sure how exactly to go about coding the query in fabrikar.