Formula or LotusScript for Combobox list

Hi,

I have combobox fields that get its data from column values. I wanted to filter the list to return only the data depending on its category.

Cat1 = column has (abc, def, hij)

Cat2 = column has (klm, nop, qrs)

.

.

.

Catn = …

So that, when I select CAT1 from field1 only abc, def, hij will appear from the combobox field’s list. I’ve inserted this code into the field2’s use formula for choices @DbColumn(“”:“NoCache”;“”:“views.nsf”;“View2”;3) but it returned all entries from the view column.

Is their anyway to filter the returned values? Thanks in advance…

Subject: Formula or LotusScript for Combobox list

How about having a flat view and then doing an @dblookup based on your value. The @dblookup will return all values that match your lookup value.

Cheers

Paul

Subject: RE: Formula or LotusScript for Combobox list

thanks I already used @DBlookup and its working…