>I need to track student’s files.
>Counselors here in Admissions dept. sometimes get these files and, either take it home or to their offices for review.
>If at that time somebody else looks for this particular file, there is no way for them to know who has it.
>
>I know there are File Tracking Systems develop by a third party, but this may not be the first choice since I am not sure if they will provide the money for it. (but it could be considered)
>
>Question:
>Does anybody have any experience developing this type of file tracking system?
>Or did anybody purchase a system like that.
>How difficult would be to implement it either way?
>
>thanks

Edgar;

You can obtain a Bar Code Printer, UPC Labels, Scanner, and software to take an existing database to create the labels. You may be able to use an existing Laser Printer. There is labor involved regardless of how you do it. I presume the records are in a manila type folder so someone would have to verify and place the label on each folder.

VFP works very well with Bar Codes by the way.

Have a Bar Code for each counselor attached to a small book with the person’s name, with two more Bar Codes for In or Out. Again there is labor involved at this point. Scan the file name, the counselor’s name and In or Out Bar Code. The date would default to today. Add four fields to the present SQL Server table, Student, Counselor, date out and date in. In case all else fails have a data entry form. Run the Bar Code Scanner to your VFP Front End and attach to SQL Server.

Tom