@DBColumn help!

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: @DBColumn help!

Use @DbLookup instead of @DbColumn

Subject: RE: @DBColumn help!

Can @DbLookup access hidden columns? First column is hidden, and I’ve got an error message “Entry not found index or view”

@DbLookup(“”:“NoCache”;“”:“dbcat.nsf”; “Categories”;CatName;“Column2”)

Subject: RE: @DBColumn help!

Yes, it can

You need to make sure that

1 - the column you are using as the lookup key is sorted

2 - the value you are looking for is in the view

Subject: RE: @DBColumn help!

I already got it running, thanks very much for your help…