Question auto reject of holiday

alright guys and girls,



just a question i am hoping for help on,



i have been serching the web and this site in terms of how to do this.



run down is...

i have a database.all the desgin and layoutas are done and adding functionallity now but i am looking for it to have holiday input form where if i enter a employee holiday then it can use a rule that if there are 3 ppl off that day it will show reject status and option to gererate a pre-formated letter in work for easy print.



i dont even know if this can be done so if anyone can advise on this???



i have got the pre generated letter,i have the employee database tables,i have emplyee form where i can add and remove employee.



i am very new and came along way but just can understand oh to tie together a yearly holiday form into bookmarks on word document with lookup.



please help me out guys



kind regards

Question auto reject of holiday