Employees and Bills due relationship
I hope someone can help, I can't seem to figure this one out:
I have an employee table and some employees are assigned mobile phones with limits, anything over the limit is charged to the employee. I have another table where all the mobile bills are inputted each month, a record of each bill is made.
Now I have no problem getting the history of the bills in a portal in the employee page, but how do create a field that gets the most recent amount due to be charged to the employee based on all the bills table when it comes to payroll day? furthermore, how do you get it to look up the amount every other payday? Hoping someone can point me in the right direction- thanks!