I have a couple custom lists, lets call them list1 and list2
lets say that list1 is a list of codes that is updated daily from an extyernal source.
list2 is my working list where we enter information, the first value entered in a field called code and I would like to have something kick off when that first field is entered and you mouse out of the field that checks list1 to see if the code exists. If it doesnt it should come back and say invalid code and not allow the screen to be entered.
can this be done??