Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

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??
Avatar of abhitrig
abhitrig
Flag of United States of America image

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)
Avatar of Matt Pinkston
Matt Pinkston

ASKER

list1 has 6,000+ entries
Was hoping for a javascript that might work
Look at SPservices on codeplex...its the javascript swiss army knife for SharePoint
I don't see anything specifically called SPservices on codeplex, do you mean JQuery?
ASKER CERTIFIED SOLUTION
Avatar of abhitrig
abhitrig
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial