I have the following 2 lists:
SCG and RPM
SCG has 2 columns:
- SOR Number(Single line of text)
- PS Number(Single line of text)
When I create a new item I create entries like this:
SOR | PS ------+-------- 1000 | 293030 2000 | 293456 3000 | 12345
And so on.
In second list RPM I have 2 fields:
- RSOR Number(look up from 1st list SOR Number column)
- PS Number(single line of text)
I want to be able to create a new item in RPM list by selecting a value from
RSOR (where values come as drop down because of the look up):
For example, if I select 2000 then the
PS Number column should auto-populate with 293456.
However Dropdown cascading is not possible because for that we should have 3 lists and here data will be dynamic in first list we can fill new items every time and cascading is for static like in city –> state -> country example which is present in many sites in internet.
Can anyone offer advice on how I should link these lists up?