In FM12, I have a field called City and State. When the user enters the city field I want "Brooklyn" to be a default unless the user changes it. Same with "NY" for state. Is there a way to do this without doing it in view database fileds and making that happen as a default there. Then it will happen all the time. Maybe I only want it to happen in certain layouts.

Mike

You can look into script triggers.

If he's actually on FM9 then it takes a plugin to do script triggers (not that there's anything wrong with that).

Another option is to use an auto-enter calculation, e.g. Case( Get(LayoutName) = "pizza" ; "Brooklyn" )

Yeah that is what I orig thought too but he started his post with "In FM12". :)

This happens every time I forget to ignore the user profile.

I guess it is time to change my user profile. Even though I have tons of stuff on 9, I'm starting with 12 now so I should use those solutions. Thanks folks.