Recording Changes While Viewing Changes and Originals
I’ve had a search in the forums for this but can’t find anything that specifically takes this solution.
I’m having a some trouble with a solution that I’m trying to implement. This is in a relation to having a list of records that are at one point in their life static and must be viewable at all times based on this static information. But Changes to curtain fields is acceptable for the next stage of their life cycle (I Hope that makes sense).
So, to try to put an example on what I’m trying to; I will have 2 tables in a DB. ORIGINALS and CHANGES. The information will be edited until the point in the ORIGINAL table that is then made static (locked). This would end up giving me a list of records in a table, lets say 1…10. What will happen is that record 2 might be then changed at a later date, add/delete/change an editable field. This would then create a record 2a that would be stored in CHANGES table. From this, I can then have the option to view the original records at the point that they were locked, 1…10, but also then see the changes that have been made, 1,2a,3...10.
Now, the first way that I looked at doing this was to just have the original list of locked records, then once a changes was made, Conditional Formatting would kick in and flag the record 2 as having changed. Here, would then add a Click button/open that would pop up another layout showing the changes to that record in a portal of sorts, so you would then see a list 2a, 2b, 2c etc, being all and each change. This way would be fine if I was only expecting changes to occur sporadically, but the way the data seems to be working, changes may be as frequent as monthly for every line, maybe even more…
So what I was looking to create, was a List type view that showed me all the records, with there most current changes, which then would pop up to show the history of their changes back to the original at point of Locking. Thus, “1,2a,3c,4a,5,6,7a,8,9,10e” might be what is displayed in the main view, then clicking on a line would pop up a layout that showed the history of that line “10,10a,10b,10c,10d”. But, also if required, it is still viewable as “1,2,3,4,5,6,7,8,9,10” upon request…
I understand if this is not possible, but this is something that would be truly great if can be achieved.
Any help is truly appreciated.
Currently working with FMPA11