Hello Everyone,
Could you please help to solve this puzzle.
I need to make a value of cells in the 2nd column dependent on the selection made in the cells in the 1st column, i.e.:
Header 1 | Header 2 |
---|---|
List An | LIst Bn |
Lists A and B have 10 items each
A1 B1
A2 B2
........
A10 B10
If A1 is selected I need a B1 appear in the second column in the same row, if A2 selected then B2,...and so on.
Could you please hep to resolve this, if at all this is possible?
Many thanks,
Andrew
Views
Replies
Total Likes
Supposing that your list is a drop down list, you could put a script like the following on the exit event of List A. (very approximate, since I don't know any of your field names)
switch (this.rawValue)
{
case "A1":
ListB.rawValue = "B1";
break;
case "A2":
ListB.rawValue = "B2";
break;
}
Obviously, you'll want to replace "ListB" with the name of your field, and possibly the references to it (ie. TableName.RowName.FieldName) and fill in more case statements all the way to A10 if that's what you need. If List B is going to be a read-only field, you may even want to make it simply a text input box and have it display the values you want it to have based on the selection from List A.
Views
Replies
Total Likes