Newbies nalexander Posted December 22, 2004 Newbies Posted December 22, 2004 I want a way to either gray out or be able to control access to related fields based on what the client selects for the primary field's answer. For example, if the client selects "Yes" from a pop up menu for the Primary field for "Was A CT Scan Done?" then they can access the remaining related fields.... "CTScan Date", "CT Scan Location", etc. But.... if they select any other value from the value list other than "Yes", I want to be able to either restrict their ability to enter in any values in the related fields (as noted above) or to have a mandatory warning pop up that won't let them. I can't seem to find a correct "IF" or "CASE" function statement that I can put in the validate calculation field for the related fields. I do have the Primary field tied up in calculation for another field, too. Any help. I have tried looking but not exactly sure what this process would be called or entered under to help facilitate a quicker and successful search. Any help or direction would be appreciated. Thanks, Nanette
-Queue- Posted December 22, 2004 Posted December 22, 2004 Don't use validation. Either use one script for each field that tests whether Was a CT Scan Done = "yes" and then Go(es) To Field or use the visibility technique to hide or disallow access to those fields when the test is false. Do a search for "visibility" to find threads that have discussed it.
Newbies nalexander Posted December 23, 2004 Author Newbies Posted December 23, 2004 Did a search both in all these forums and in my Help guide in the FMP 6 application and nothing was found. The only thread for "visibility" was yours and what they talked about from what showed after my search in the Vers 6 application in no way resembled anything that I am trying to do. I know that this is possible with Access, but I am not a programming whiz nor want to use Access, so I am still in limbo on how to do this. I'll try a script for the next field, but I don't want to have to make up 50+ different scripts for something that we should be able to do otherwise during development and formatting. Nanette
bruceR Posted December 23, 2004 Posted December 23, 2004 When you downloaded and tested the visibility examples, what happened?
stuj1026 Posted December 23, 2004 Posted December 23, 2004 The visibility trick will work but there are a number of other ways to accomplish this as well. Just take the ctscan_date, ct scan location, etc.... and turn them into buttons. Set those fields as not being able to enter in browse mode thruogh field behaviour ( you are using fm7 correct?)and also set a script to each one of those fileds. _______________________________________ if (was a ct cat scan done) = yes goto field ct catscan location else show message ( access denied) end if __________________________________________ The goto field will put you into the field even though it is set to not be accessed in browse mode. Set this script to each field that you conditionaly want access to. Hope this helps Stu
-Queue- Posted December 23, 2004 Posted December 23, 2004 Nanette, I suspect that your search included 1 week in the date range. Remove the 1 and make sure to search All Forums and you will find several threads, some dating back to 2002. Stu, thank you for elaborating on my terse description of using the fields as buttons.
Newbies nalexander Posted December 23, 2004 Author Newbies Posted December 23, 2004 Thank you all for your response and help. I am not using 7 for this database just yet. I am working with government clients and not all are upgraded to 7 as yet nor can I ask them to go to it just yet, so I am doing it in 6 right now. I found a large amount of visibility information and the download file and will give it a look over and see if anything there can help me. I'll also see if I can write the scripts for these Primary fields to limit access to the others. Right now I just put up a validation calculation and message to get a response out of the client, and let them know I was looking for better solutions. I'll let everyone know how it goes. Thanks Nanette
Recommended Posts
This topic is 7344 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