9 replies to this topic

[itmedex]

We have a field that builds its value list off of itself. When a user enters find mode, the list will display the same value, in this case 2011. How does one change the value to display 2012?

[Lee Smith]

Hi itmedex,

There are a couple places you can check, the 1st one I mentioned is probably where you are going to need to change it. Go into your Manage Databases, click on the current field, click on the Option for that field, & see if there os an Auto Enter of 2011. If not, you will need to edit the value lists to include 2012.

HTH

Lee

[bcooney]

"When a user enters find mode, the list will display the same value, in this case 2011. How does one change the value to display 2012?"

What do you mean? It displays the same value as what? The last record viewed?

To set a default in FIND, you'll need to script it.

Enter Find Mode
Set Field (myField, "2012")
Pause
Perform Find

[itmedex]

I solved this mystery. Somebody went and setup a OnViewChange script trigger that was setting the year to 2011 when the user entered find mode. Once I found it and changed it, everything worked fine. Thanks for your help.

[bcooney]

That is one reason I hate triggers. They hide. Good for you that you found it.

[comment]

That is one reason I hate triggers. They hide.

If you'll pardon the allusion: Triggers don't hide - developers hide.

[bcooney]

Huh? To me, they're right up there with auto-enter calcs.

[comment]

I meant:

Attached Files

•  ShowLayoutTrigger.zip   6.38K   19 downloads

[bcooney]

That is definitely a best practice, and we've done similar for "hidden" tab panels, etc. However, I contend that it would be much nicer if FM natively could call your attention to such triggers.

[comment]

I agree. But since that's not likely to happen...