I have fallowing problem, On form I have two fields one use Combobox and I use Dbcolumn to put there value for choice. And when I choice one of possibility value I want search it on first column on the view and next put to second field value from second column (only value from the same row what key) I use Dblookup but it return all value from column two and put it to second field.
Pleas help me.
Subject: RE: Problem with select right value from view
You have a combobox field (fieldA) with a keyword formula that uses @DbColumn. When the user selects a value in fieldA, you want a computed field (fieldB) to display values from a view column (column 2), but only from those view rows where the value in column 1 matches the value in fieldA.
To do this, the “value” formula for computed field fieldB uses @DbLookup with fieldA as the key. However, all the values in column 2 appear in fieldB, not just the ones from rows that match fieldA.
Have I understood your question correctly?
Especially, please tell am I correct that FieldB is computed and that the @DbLookup is in its value formula? If not, we need to know the exact details of the field types and which formulas appear where.
Please tell the actual fieldnames and the name and alias of the view you are using with @DbLookup.
Please show the formula you are using to calculate the value of fieldB.
What options are selected for fieldA? Especially, is “refresh fields on keyword change” ticked?
Is the column that contains the values from fieldA, the first sorted column in the view?
What is the datatype of the values in column 1? Text, number, date…?
Did the value in fieldB change when you selected a value in fieldA, or did it already contain all the values from column2 before you made your selection?
Subject: RE: Problem with select right value from view
It works Thank you very much, and I Wish You happy new year.
Subject: RE: Problem with select right value from view
Pretty difficult to establish the problem without reviewing the code you are using.
Why not paste to DbLookup statement you are using so we can have a look?