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 ;)