self study class

[chuckie]

i need to monitor people in a self study classroom as they checked in and out there name would be added to a portal what pc they were asigned to and the time they checked in . i think i could use a drop down list based on the number of pc's in the room. when there record was retreived from the search will be able to asign a pc# then it would time stamp and add to portal bottom of record screen when they checked out could click button on there row in portal to time stamp and remove from portal kind of like the lending libary i need to generate reports how many times and how long each person was in the room this should be simple i am lost on the scripting for the portal i don't even need a portal just a way to track the users

thanks ahead of time

charles b

[dkemme]

We do this in our office in the following way: Create a script that is called whenevery the database is opened that will create a new record in a table called Log. In Log have a field that is autoenter Get ( SystemIPAddress ) as well as a datetime filed autoenter get (datetimepstamp ) and the accountname of the user that logged in. You could also have a field for when they log out, set with a script upon closing the file. To see this in a portal, create a layout with a relationship to Log, I would use a 1:1 relationship to see all the fields, sorted by datetimestamp, should allow you to see in realtime who is active. You will need to make sure users log in and out with each use.