tbcomputerguy Posted September 14, 2015 Posted September 14, 2015 Hello again, long time since I visited. I have setup a curling membership database to record all pertenant info; being which league, the team they are on, team position etc. But now I want to create a new years worth of data. I thought about this at its inception but time got the better of me and I negelected it. My thoughts were that I create a new year table, then create a new record in that table. then, when I create new team or member have it populate a current year field in the respective tables with the value of the current year. or curryr_ID. This way when a new record is created, it will have that ID attached to it. Follow me?
Fitch Posted September 14, 2015 Posted September 14, 2015 A year or date is usually a field. What's the purpose of the "new year" table?
Rick Whitelaw Posted September 16, 2015 Posted September 16, 2015 I actually have a table called Years in my solution. It contains only one field: the year. It turns out it serves a great purpose. All tables related to it are only related, of course, by this field.
Fitch Posted September 16, 2015 Posted September 16, 2015 If I'm understanding the original question, if the desired result is to auto-enter the current year: Year( Get(CurrentDate) ) OTOH if the year number you need is not always the current one then the approach you described makes a little more sense.
Recommended Posts
This topic is 3367 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