Using Two Resource Table for Storing and Update

Is there a way to have two tables in the database—one for storing initial item details like item name, price, quantity, and date, and another with the same data but we can performing increments and decrements, continuously updating the data? Ideally, when we 'create' an initial resource the data should be automatically added to both tables in sequence?
Solution:
I don't really get what you are trying to do and why. But I guess you can override the save logic on both Create and EditPage to save to both tables
Jump to solution
3 Replies
sadiqgoni13
sadiqgoni138mo ago
.
Solution
Dennis Koch
Dennis Koch8mo ago
I don't really get what you are trying to do and why. But I guess you can override the save logic on both Create and EditPage to save to both tables
sadiqgoni13
sadiqgoni138mo ago
Alright Thankyou Yes I solved it using Observer now even if entries are deleted from the primary records, their complete history is preserved in the secondary table . Thankyou @Dennis Koch