Newbies doostin Posted May 17, 2007 Newbies Posted May 17, 2007 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
Newbies doostin Posted May 17, 2007 Author Newbies Posted May 17, 2007 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!
John Mark Osborne Posted May 17, 2007 Posted May 17, 2007 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".
Recommended Posts
This topic is 6400 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now