I have a "Project" list library and a filed needs to specify the contract sum of that project. e.g 500000
I could also add another two columns as lowRange and HighRange e.g 100000 to 200000
So the list record would be
Project=ABC , lowRange=100000, HighRange=500000, ContractSum=500000
Project=CED, lowRane=500001, HighRange=1000000, ContractSum=750000
Project=EFG, lowRane=500001, HighRange=1000000, ContractSum=950000
When user filter or search a value 800000, CED and EFG list records will be shown
When user filter or search a value 250000, only ABC will shown..
Please advise what the best way to implement this ... ?!