I have a database with an Employees table and a DataRecords table. It
is a one-to-many relationship.
Would it be possible to allow the Employees to enter their own records
via the web using internet explorer? In fact, ideally they would need
to login with some sort of EmployeeID and password (would this be stored
in the Employees table?) and then they would have certain access rights
(i.e. able to add a record, view/print certain reports). It would also
be necessary for a manager/administrator to have full access.
This would be ideal because it would save on having 50 employees fill
out sheets and hand them in to another employee who has to enter 250
records every month. It would also allow the employee to view their own
reports, or their team's reports, without having to make calls or send
e-mails, etc...they could just login and view what they want.
Well, this is uncharted territory for me, but I have been asked about
the possiblity of doing this. What options are there? Thanks!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!