I need to filter a lookup list control based on the amount entered by the user, I need all the items from the list where Amount < the amount entered by the user.
Or is it possible to use JQuery to fill the loopup list
in control setting-list lookup window is a section named filtering
change "Filter available selections" to "by a control's value"
in "Where field" type the column which you want to set filter on it
in "Filtered by control" select the control which user enters the amount
it's all done to fine!
oh, you're right! Unfortunately filtering just return equals value and I dont know how solve your problem!
i share your question in my coworkers group, maybe they can help us