Hello Everyone,
I have this small system that i developed for a company that is basically a Skill Map for the employee's, so in the following image will show the search of the employee's skills through the Family, in the following image the users does a search of the family and it will show all the employees which have learned a manual of that family:
http://www.daniweb.com/forums/attachment.php?attachmentid=20347&stc=1&d=1301518355
So there is another form which is called IDO(SkillMap3.jpg)
http://www.daniweb.com/forums/attachment.php?attachmentid=20349&stc=1&d=1301518949
Which are all the Manuals under each family Example
Manual,Revision,Family
ENSAMBLE DE FRENO LADO DE SERVICIO,1,TANDEM OMNI & WABCO
PRUEBA DE FUGA A FRENO TANDEM Y HALF STROKE,0,TANDEM OMNI & WABCO
PRUEBA DE FUGA A FRENO TANDEM Y HALF STROKE,0,TANDEM OMNI & WABCO
RETOQUE DE PINTURA,1,TANDEM OMNI & WABCO
PRUEBA DE FUGA A FRENO TANDEM EN CARRUSEL,2,TANDEM OMNI & WABCO
Each manual handles a revision, so what i need to do is the following:
When i do the Search By.. Family, and displays all the employee that have that attribute under that Family, i need to compare each employee revision attribute with the current revision in the IDO form, View the following image:
http://www.daniweb.com/forums/attachment.php?attachmentid=20351&stc=1&d=1301520450
And if the Revision on the IDO Form Changes for example from 1 to 2, and the user is learned the revision 1, i need to highlight that user in red.
I've been trying to work on this for some days now and i havent been able to get it, does anyone have an idea on how to do that?
Thanks in Advance!
