If I have a table in a form that the user enters data in to, is there anyway that it can be sorted and yet keep all the info in the row together?
Here's an example:
In the table below the user needs to enter all the data fortnightly for payroll, as payroll requires employees to be entered in numerical order according to their employee number each time someone leaves they have to delete them then move everybody up a row, the rows also add up hours (the example shows hours paid in the form there are columns for sick leave etc also and they total at the end of each row....any ideas on how I can make this easier to use? (keeping in mine I'm a novice)
Employee number | Name | Hours paid |
---|
001 | J.Smith | 70 |
002 | S.Black | 55 |
003 | K.White | 60 |
004 | D.Jones | 65 |