Need a SharePoint List Trick

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.

code1
code2
code3
code4

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??
Matt PinkstonAsked:
Who is Participating?
 
abhitrigCommented:
Can't you create a lookup in your list2 to the list1 and make it required? That way the users have to choose an existing code.

if you still need to do this, yes you can use javascript to make a call to the list (webservices if using 2007)  by using the client obejct model (if using  2010)
0
 
Matt PinkstonAuthor Commented:
list1 has 6,000+ entries
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Matt PinkstonAuthor Commented:
Was hoping for a javascript that might work
0
 
abhitrigCommented:
Look at SPservices on codeplex...its the javascript swiss army knife for SharePoint
0
 
Matt PinkstonAuthor Commented:
I don't see anything specifically called SPservices on codeplex, do you mean JQuery?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.