I need to code the following logic is a CF page.
If I list each requirement, could someone help with the code?
These are the two DB tables I already have.
MS Access DB table 'A' has the following fields:
MS Access DB table 'B' has the following fields:
This is what I need the CF code to do in one CF page:
1. query the 'A' table and get the difference between the 'Total' and 'Actuals' fields for each INumber and call it 'hours'.
2. List each Employee from 'B' table.
3. Spread the available 'hours' evenly for each employee, display the hours and display the 'INumber' (write this value to 'B' table, field 'INumber' )and 'ICodeNumber'(write this value to 'B' table, field 'ICodeNumber').
4. A maximum allocation of 9 hours per employee, per INumber.
(write this value to 'B' table, field 'HoursAssigned')
5. A maximum of 43 hours per employee total for all INumber hours allocated per employee.
(write this value to 'B' table, field 'TotalHours')
If you have any questions, please let me know.