I am trying to create a database that will track points earned by my employees.
I want to be able to create two forms, one for myself to add points to each employee and then one where the employee subtracts points by usinging them.
It would be nice to be able to track the transactions as well. (dates and #of points coming in and dates and # of points going out)
Would there be a way that the forms can be set up with out the employee having access to the main table and just the form.
I would also like to be able set it up where the employee or myself can see the total number of available points.