Employee based database, which creates new files (rows) by date
I would like to create a layout that will be universal to all employees, not a problem on my end. The problem I am having is when the user will go into their form (ID#) I would like the current date to pop up and allow them to fill out the form based on todays date, and if they forgot to fill out or would like to edit a previous date they can put the date in and the previous data will pop up in the appropriate fields for editing. I was thinking the dates would be placed down the rows so each table would be employee based, but if the table was employee and date based that would be fine as long as the data can be looked up by employee and date.
So a databse for each employee and that database is updated daily with there progress in designated fields.I hope this is enough.