Greetings,

I was wondering if there was some way that you could disable a text box (for example) if another field has a certin value in it.

i imagion i can get the if statement and alike working, however i can't seem to find anything that is simular to making a box deactive.

You can make the second field be a button with a script attached. If the first field does not have a value in it then the script could get to it with Go to Field [].

You could also use field level access as well as the visibility trick. You can do an advanced search for them.

You can make the second field be a button with a script attached. If the first field does not have a value in it then the script could get to it with Go to Field [].

You could also use field level access as well as the visibility trick. You can do an advanced search for them.

There must be someway of deactiving a text box in Filemaker, surely someone else must have had the simular experience before.

There is not a direct native way to deactivate entry into a field conditionally. You will have to use one of the workarounds.

That's the joy of filemaker! Awkward layouts...

The visibility trick works nicely. Yes it would be cool to have an option to display a field based on a calculation, but that works fine.

Plus if you get creative you can use relationships (and portals) to create some pretty neat "functionality". Example: Dynamically changing buttons, conditionally displayed data/fields, etc.

What visibility trick in FM? Didn't know that it was possible to change the visibility dynamically. If so how?

http://fmforums.com/forum/showtopic.php?tid/198234/post/303977/hl/visibility/fromsearch/1/#303977

As good as the trick is...its power lays in the principle it uses. Takes some creative thinking, but you can work some "magic".

Edited October 7, 200817 yr by Guest

Ok, I guess you need FM 9...

No, you only need 7 or higher. The demo file is from the Database Pros site.

No, you only need version 3 or higher.

It would be sooo nice if there were only a property named "visible" with a true or false value à la VB...

Imagine how it would keep the DB schema easier to read.

Thanks for the correction Michael.

I couldn't say it for sure...I haven't been around FM that long. So I was being safe...because I knew he was using 8.5. :Whistle: