Henry Posted June 23, 2003 Posted June 23, 2003 Hi there, now i want to ask how to set a field enable entry from from false to true (like in visual basic). For example, i have 2 field, temp1 and temp2. Temp1 is a list with 2 selection, true & false; temp2 is normal text entry field. The field temp2 cannot by entry by user unless they select the value "true" in temp1. Regards Henry
Vaughan Posted June 23, 2003 Posted June 23, 2003 Noting directly parallel in FMP. You could do something using field validation (validate by calculation) but it'll be slightly different: the user will be able to type into the second field and will only receive the alert after they click out of the field. Not really a good interface.
Ugo DI LUCA Posted June 23, 2003 Posted June 23, 2003 Or set a transparent button behind your field 2, disallow entry to that field, and use a script : If Field 1 = Your value for locker Exit script Else Goto field 2
Lee Smith Posted June 23, 2003 Posted June 23, 2003 You might take a look at a file by John Mark Osborne called VISIBLE available at his site http://www.databasepros.com/ HTH Lee
Anatoli Posted June 23, 2003 Posted June 23, 2003 RE: The field temp2 cannot by entry by user unless they select the value "true" in temp1. In that case you can put portal with self-relation which will show/hide the second field. Probably something like Lee is pointing to with JMO link.
Lee Smith Posted June 23, 2003 Posted June 23, 2003 Hi Ugo, Yes, but if they select the majic word "true", then bingo Temp 2 appears for entry. Or did I miss something here? Lee
Ugo DI LUCA Posted June 23, 2003 Posted June 23, 2003 The example given was pretty abstract. Suppose you have a Price field. You need to know the price, and see it, but you would only be able to alter it if the customer selected is a "Professional" from a previous drop down (could have been a lookup here )
Recommended Posts
This topic is 7827 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