I have two lists - list A with columns A,B and C (all types number). Then list B - with columns number (type number), text (type text), category (type text) with following lines:
1, text 1, A
2, text 2, A
3, text 3, B
4, text 4, C

And I want following - if i add new line in list A, i want to make dropdown list - for column A with only text 1 and text 2 (and in column A will save number 1 or 2), for column B text 3, etc.

I managed to make dropdown list with all lines from list B, but I don't know, how to filter it.

I hope I wrote it clear and sry for my English ;)


The term you are looking for is Cascaded Drop downs.. On selection of one drop down the other filters..

You can achieve them using SPServices Cascading Drop down Javascript Library

Or you can use InfoPath Forms (customize list forms in InfoPath) to achieve Cascaded Dropdowns

|improve this answer|||||
  • Ok, thanks. Unfortunately I do not have permission to the server to upload new library, so I try Infopath. – ludvik14ty Jun 5 '14 at 11:28
  • Okay, if that answers your question.. Please tick mark it to close the question.. (Of course after you have tried the solution) – Arsalan Adam Khatri Jun 5 '14 at 11:47
  • I tried it... but I have problem with InfoPath, because on server is InfoPath service not running. But I managed to make it with filtered Data Source and it works :) – ludvik14ty Jun 5 '14 at 12:17
  • Great.. tick mark the answer please :) – Arsalan Adam Khatri Jun 5 '14 at 12:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.