Auto-entered dates which roll over

[nickp]

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.

[BobWeaver]

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.

[LiveOak]

You'll need to keep working on "decently proficient"!

-bd

[nickp]

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" don't take me out of context. : ) thanks for the words of umm.. encouragem.. umm.. well whatever

-nickp