adewale4favour
Registered User.
- Local time
- Today, 12:31
- Joined
- Aug 9, 2019
- Messages
- 55
Hello!,
I am Michael.
I will appreciate getting assisted in figuring this out.
I have a form with two Combo boxes, both are dependent. Now what I want to achieve is, Example, in Combo Box A TYPE, I have options like HP, Lenovo, Dell etc, and Combo box B, I have options like YEAR: Released 2003, Released 2005, Released 2008 etc. Now, I want users who select Lenovo to be mandated to select the year of released. If other options are selected, they can skip the year of released.
I thought this could be done from the Validation rule, I used this line of Validation([TYPE]="LENOVO" And [YEAR_RELEASED] Is Not Null) Or ([TYPE]<>"LENOVO" And [YEAR_RELEASED] Is Null))
This isn't working.
thanks
I am Michael.
I will appreciate getting assisted in figuring this out.
I have a form with two Combo boxes, both are dependent. Now what I want to achieve is, Example, in Combo Box A TYPE, I have options like HP, Lenovo, Dell etc, and Combo box B, I have options like YEAR: Released 2003, Released 2005, Released 2008 etc. Now, I want users who select Lenovo to be mandated to select the year of released. If other options are selected, they can skip the year of released.
I thought this could be done from the Validation rule, I used this line of Validation([TYPE]="LENOVO" And [YEAR_RELEASED] Is Not Null) Or ([TYPE]<>"LENOVO" And [YEAR_RELEASED] Is Null))
This isn't working.
thanks