selecting a value based upon 2 columns

[ajaypaidi]

HI gurus,
i need to select a value based upon 2 columns.for instance,i have table A and Table B where Table A has 2,3,4,5 values and Table B has D,E,F,G,H,I,J,K L,M which is related to Table A in such a way that 2-Dand 3-E,F,Gand 4-H,I,J and 5-K,L,M. i need to select a value in Table B where Table A value is 2.thanks in advance

[gits]

hi ...

please post some code you already have and explain where you have problems with it ...

kind regards

[ajaypaidi]

hi ...

kind regards

var temp1=ActiveDocument.Sections["Results Gender Proflie Matrix"].Limits["Business Level"].SelectedValues.Count;
Alert(temp1);
var temp2=ActiveDocument.Sections["Results Gender Proflie Matrix"].Limits["Business Descr"].AvailableValues.Count;
Alert(temp2);
for(var j=1;j<=temp1;j++)
{
for(var k=1;k<=temp2;k++)
{
  if(ActiveDocument.Sections["Results Gender Proflie Matrix"].Limits["Business Level"].SelectedValues.Item(j)==2)
{
Alert(k);//what is the statement i should write here.the code below is faulty.
var test1=ActiveDocument.Sections["Results Gender Proflie Matrix"].Limits["Business Descr"].SelectedValues.Item(k);
Alert(test1);
//i need  the above value.
}
}
}/*

[acoder]

Please use code tags when posting code:

[CODE=javascript]
JavaScript code here...
[/code]