Table below us summery of the days work for a given employee. I am using Forms 10 Calculation functionality to gather the totals for "Total Machine Hours" and "Indirect Hours". All the employee needs to do is enter his actual hours he worked in the "Total Pay Hours" field. The Submit remains hidden.
Here is the decision:
1) If the Total Pay Hours is LESS than Total Machine hours, then the Submit should display. And a prompt should appear prompting user to change all "Indirect Hours" listed in the table to a '0' value.
2) If the Total Pay Hours is MORE than the Total Machine hours, then the employee needs to be prompted to add additional "Indirect hours" to the table to make up the difference.
I tried accomplishing this with the new Forms 10 calculations ability, but have only gotten one or the other mostly successful. Any suggestions?