Adding fields from a previous record in a portal!
Hi everyone! I have a layout that has 3 fields (ID NUMBER, NO. OF HRS, TOTAL HRS.) in a portal. The ID NUMBER field is a drop down list, where I can choose the id number of my employees. The NO. OF HRS. will contain the no of hours they worked for the day and the TOTAL HRS. will contain the total numbers of hours worked. This is how it works, I will fill in the corresponding values for each field for the day and I will do the same thing the following day, but how can I add the number of hours worked from the previous day to the current day for the same ID number?
Thank you everyone, any help is greatly appreciated!