Dear Ron,
The answer is a simple one, and you already own it: the FrontPage
Database Results Wizard.
Create a registration page where employees create a username &
password, and a log-in page where access to the 'availability' area is
limited to logged-in employees. An example of this can be found at
http://home.att.net/~codeLibrary/FrontPage/drws_p.htm - this uses
nothing but the FrontPage Database Results Wizard.
Create a page in that area with the form for employees to input their
availabilty; include a timestamp (it's built in). Then create a page
that returns their info, including time, and listed by employee or by
latest entry using the Database Results Wizard (Insert -> Database ->
Results...). Since you want only that employees to access their own
specific records in the database, the passed session variable (meaning
identifying that specific employees from their log-in credentials) can
be used in the Database Results Wizard SELECT SQL statement, such as:
SELECT * FROM TableName WHERE UID = ::uid::
A page, for the secretary, showing availability, is then created using
the Database Results Wizard. Either it can auto-refresh every so-often,
or she can do it manually.
Good luck, Ron; I expect fantastic things from you.
Nicholas Savalas -
http://savalas.tv
--------------------------------------------------