May 17, 200718 yr Newbies I think this might be a strange one, or a simple one, I have no idea. Lets say I have two fields: Payment Amount and Payment Type These fields aren't always used so I can't make either one of them a requirement to fill out. However I would like if they enter a "payment amount" that payment type becomes required. Is there a way to do this? I was thinking a validation calculation? I'm not even sure how to approach this. Thanks for the help! Dustin
May 17, 200718 yr Author Newbies I should probably say I posted here under Value Lists because the "payment type" field is validated by a value list. If it makes sense to be posted elsewhere please let me know, thanks!
May 17, 200718 yr This should work: Case( IsEmpty(Payment_Amount); 1; not IsEmpty(Payment_Type); 1 ) Make sure to uncheck the option "validate only if field has been modified".
Create an account or sign in to comment