Jump to content

Duplicating Tables


Hugh2
 Share

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

Recommended Posts

I am fairly new to v8.5 and am creating a database to capture data over multiple years. Data elements will be the same for each year and I am thinking about a table for each year with the same fields. Is there a way to create one table (Year1) and duplicate it (Year2, Year3, etc)? I see how I can have multiple occurrences of a table but this is just the same table with the same fields isn't it? Am I barking up the wrong tree? Is there another approach? Thanks in advance.

Link to comment
Share on other sites

Wouldnt it make more sense to have one table with all your data, a field that designates what year the data is for and then group by year to get a particular year's data?

Link to comment
Share on other sites

But then you would be limited to the number of tabs you create. It may be better to use a global field to set the year that you want to view the data from. A realtionship would be created from this field to the year field in your table. So when the global field is set to lets say 2005, then only the related records with the year 2005 could be displayed, for example in a portal.

Link to comment
Share on other sites

This topic is 5705 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
 Share

×
×
  • Create New...

Important Information

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