physixz Posted March 24, 2016 Share Posted March 24, 2016 Hi, I have been given the task of upgrading and improving our solution at work which consists of 9 files. I've started by identifying the problems such as data loss or unexpected things happening and have focussed on one file to start with. In an offline file I have made my changes and the file is much more robust and easier to use but the problem is I've made changes on the relationship graph so the data is broken. This is not a major problem as because the data was incorrect it would have taken too much effort to fix but what we would like to do is archive the data, kind of like take a snapshot at which the data can then no longer be changed but can be viewed for traceability. The file is used as a stock database and has all of the transactions for each item. With my changes the transactions are lost, they are in a separate table. I was thinking if I renamed the table and then create a portal on a new table called archived I could then copy the table and delete the data from the new table and make my changes. Would this work? I have attached an image of part of the relationship graph, the table is called Stock entry and it only has one occurrence as shown Link to comment Share on other sites More sharing options...
Fitch Posted March 25, 2016 Share Posted March 25, 2016 Maybe. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3081 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