Jump to content

Duplicating records


susan
 Share

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

Recommended Posts

I'm not sure if this is the right place for this post...forgive me if it's not.

I have a solution I'm using in a school where the grade of the student in the DB needs to be changed each fall. I have that figured out. However, the teachers want to keep all the data from previous years, so instead of simply changing the grade I need to duplicate each record and then change the grade on only one.

In my mind I've solved this by exporting all the records--running my ChangeGrade script--importing the records just exported. I would put all this in one script which would run when the solution is launched if Today'sDate=September 1.

Does this make sense? Is there a better way to do it?

Thanks.

Susan

Link to comment
Share on other sites

A little more advanced idea is to have two files: Students and Grades (or School Years, etc). These files would be related by a StudentID#. Each student record in Students can then display a list of grades for each student. New grades can be entered by clicking in the next empty portal row (if the relationship is set to "allow creation of related records"). Using this approach all the student data doesn't need to be duplicated in another set of records in the same file.

-bd

Link to comment
Share on other sites

This topic is 7301 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.