Sure, I'm not concern with the labor involved. I just need to see what would be feasible.
You make a good point, obtaining the Bar code printer, upc labels an scanner
I got to check how much these things cost.

thanks Thomas



>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