Newbies nickp Posted February 7, 2001 Newbies Posted February 7, 2001 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 Posted February 10, 2001 Posted February 10, 2001 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 Posted February 10, 2001 Posted February 10, 2001 You'll need to keep working on "decently proficient"! -bd
Newbies nickp Posted February 13, 2001 Author Newbies Posted February 13, 2001 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now