I have two pull down menu's one called presenter and the other teachers assitants. these two drop down menus offer the same selction in there menus, from a list of staff members. I would like to have it so the database will not allow the same person to be selected in the presenter and teachers assitant field. I would also like to have it so a person can only be selected once in the teachers assitants field. I would assume that I could use the valiadation rule for to accomplish this task. Any advice is appreciated.
thanks
thanks