Hoosty2 Posted December 5, 2001 Share Posted December 5, 2001 Lets say we have two fields. Field A and Field B. Field A can only be in two states "Yes" and No" If Feild A = "No" then Field B will allow modification with a value list assigned to it. If Field A = "Yes" then Field B will be locked. Thanks for your help in this matter. Quote Link to comment Share on other sites More sharing options...
David Head Posted December 5, 2001 Share Posted December 5, 2001 Set the options of FieldB to be validated by calculation: FieldA and IsEmpty(FieldB) or not FieldA Make it strict and add a custom message like "You cannot select a value for FieldB when FieldA is Yes". Also, I would set FieldA to have an auto-entered value of No and validate to be strictly not empty. Quote Link to comment Share on other sites More sharing options...
Hoosty2 Posted December 5, 2001 Author Share Posted December 5, 2001 David, thanks fo the help, I want the field A to be able to be changed by the ppeople working on it. If they select "No" in Field A then field B locks. If they select "Yes" then they are allowed to enter info into Field B This is if I change to yes in field A then I am locked outdoing anything. Quote Link to comment Share on other sites More sharing options...
Hoosty2 Posted December 5, 2001 Author Share Posted December 5, 2001 Let me retry something Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.