Dbcolumn list & select a value based on Dblookup

HCL Domino Domino Forum
1

Hello All, I have 2 combobox in web.

Field1 :- Technology

Field2: All names (Using dbcolumn)

Field2 contain all names.

Now my condition is when I select the Technology against that technology SPOC names will be selected from Field2 list value.

example: Filed2 contain

A

B

C

If I chose Field1 (“Lotus Notes”) as a technology. from Filed2 A and B should select. C should not select.

Which shows A and B are SPOC members of Lotus Notes technology.

2

Subject: Dbcolumn list & select a value based on Dblookup

Hello Friends, Got the answer. I have used javascript to handle the situaltion. And call the javascript funtion onload of form

function funselectSPOC()

{

var b = document.forms[0].AllSPOCValue.value;

var temp = new Array();

temp = b.split(‘,’);

for (var i = 0; i < document.forms[0].txtSPOCName.options.length; i++)

{

for (var j = 0; j < temp.length; j++)

{

if (document.forms[0].txtSPOCName.options[i].text==ltrim(temp[j]))

{

document.forms[0].txtSPOCName.options[i].selected=true

		}

}

}

}