Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8671 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Hello,

I am a first-year college student and very new to this board and (5 minutes or so) and fairly new to Filemaker Pro. I am decently proficient, all things considered, I guess.

Anyway, I am having problems taking care of one task. I need to create a database which keeps track of years of service for teachers. The year that they started would be entered into one field and I want the other one to just say how many years they have been in service .

I set it up to auto-enter the current year by a defined value...

the problem is this: when i change the current year, NEW records will show the change, but the records that were already in still show the same date.

How can I get all of the records to roll over?

Any suggestions?

Thanks in advance,

Nick P.

Posted

I think I saw this post in another forum, but I'll answer it just in case.

You need a calculation field rather than an autoentered field. As you found out, autoenter is really intended for setting an initial default value which the user can then change as necessary. It never updates after there is data in it. A calculated field will update whenever one of the fields that it uses is modified.

  • Newbies
Posted

Bob,

Thanks for your help I will see what I can do with that advice.

LiveOak

that's "decently proficient, all things considered, I guess" wink.gif don't take me out of context. : ) thanks for the words of umm.. encouragem.. umm.. well whatever

-nickp

This topic is 8671 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.