Domino Code Fragment

Code Name*
Dependant keyword List. 		Date*
04/28/2024		Source (or email address if you prefer)*
Rlatulippe@romac.com
IP address:.18.191.228.88
Description*
Final list depends on selection of second list which depends on selection of first list.		Type*
Formula		Categories*
(Misc)
Implementation:
Required Client:
Server:
Limitations:
Comments:
Files/Graphics attachments (if applicable): Code:

Working on a database form that has 3 keyword fields in it. You want to have a formula that will look at the first keyword field and
use that to pick another set to the subsequent keyword2 and then from that selection keyword3.

So for example, if keyword1 was (Car,Utility, Truck) the selection car would show in keyword2 (Ford, Toyota, Honda).
The selection Ford would show in keyword3 ford cars (mustang, escort, tarus, etc....)


Create a keyword field and have it set to Use Formulas for Choices

Use this formula: Now wasn't that easy ;-) Of course you will have to complete it.

@If(
@Prompt([OKCANCELLIST]; "Vehical"; "Select a vehical."; "Car"; "Car": "Utility" : "Truck") = "Car";
@If(
@Prompt([OKCANCELLIST]; "Auto Maker"; "Select an Auto Maker."; "Ford"; "Ford":"Toyota": "Honda") = "Ford";
"Mustang" : "Escort" : "Tarus"; "");"");