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

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.

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

You might take a look at a file by John Mark Osborne called VISIBLE available at his site

http://www.databasepros.com/

HTH

Lee

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.

But then it is unabled because invisible....

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

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 )

I think Lee has hit the nail on the head.