I have 2 combobox on my Domino Designer. I want that the choices from the second combobox will depend on what will I choose on the first combobox. What formula can I use? Thank you.
Subject: Description of how to design what you want
Hi. The first field should be set to Refresh fields on keyword change in the Field properties dialogbox. The second Combobox should be set in it’s field properties to Refresh choices on document refresh. Also, in your second Combobox Choices area of the field properties dialogbox, select Use formula for choices. Your formula should use the first Combobox field name in an if statement. If you want two values for your second Combobox and your first Combobox has 3 values of firstchoicevalue, secondchoicevalue, and thirdchoicevalue, then your formula might look like something like @If (Combobox1fieldname=“firstchoicevalue”;“choice1”:“choice2”;Combobox1fieldname=“secondchoicevalue”;“anotherchoice1”:“anotherchoice2”;“lastchoice1”:“lastchoice2”). Notice how the choices for the second Combobox are separated with colons.
Subject: Formula
Use @dblookup 
see a sample here >> www.jhengliwanag.com/lesson-1
but my sample is in Tagalog… I hope you can still understand and learn from the vid
Subject: If both Combobox fields are on the same form, then no need for an @DbLookup
Hello, JhengPot Liwanag. If both fields are on the same form as the author seems to imply, then there is no need to do an @DbLookup. That would be using more code than is necessary. Please see my first response for an explanation. Thanks.