Hi everybody,
I searched the forum many times, but I found the solution:
My Problem:
A Form wth two Comboboxes, getting there values from the same Keyword document.
Example (text):
Audi$A1|A2|A3|A4|A6|A8
Mercedes$E200|E220|S300|S500
Mitsubishi$Colt|Pajero
Volvo$740|C40|V70
I select a value in the first combobox (editable) from
Audi, Mercedes, Mitsubishi, Volvo
In the second Combobox I want to select from 740, C40, V70 when volvo was selected.
Here are the selection formulas:
Field Productgroup (ComboBox 1):
keyname:= “.ProductGroupType”;
res:= @DbLookup(“”:“NoCache”;“”:“”;“Keywords”;keyname;2);
tmp:= @Word(res;“$”;1);
tmp
Field Producttype (ComboBox 2):
FIELD productgruppe := productgroup;
keyname:= “.ProductGroupType”;
res:=@DbLookup(“”:“NoCache”;“”:“”;“Keywords”;keyname;2);
tmp:= @Word(res;“$”;1);
pos:= @Member(@Trim(Productgruppe);@Trim(@Word(tmp;“$”;1)));
choice:= @Explode(@Subset(@Subset(@Word(res;“$”;2);pos);-1);“|”);
choice
I works fine in the Notes client but not on web.
Database Properties:
Use javascript when generating pages: checked
Form Properties:
Automatically refresh fiels: checked
Render Pass trough HTML in Notes; checked
Field Properties:
Refresh Fields on Keyword Change: checked
Refresh choices on Keyword change: checked
Field Productgroup: Onchange event: _doClick(‘$Refresh’,this,‘_self’);
So whatelse is to do, or do I have to change my Keywords.
TIA
Sebastian