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

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

Recommended Posts

Posted

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?

Posted

A year or date is usually a field. What's the purpose of the "new year" table?

Posted

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. 

Posted

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.

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 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.