I am creating a CostHistory table in my database, containing:
The idea is that we keep history of the cost values for various costs stored in the system. Each cost has a date range where it is effective. Consider this a poor man’s temporal table.
I am looking for the best way to put up a screen to maintain this. I don’t really want a Master/Detail editor. I prefer to edit in the table itself. It seems to be a cross between a StandardLookup and a StandardEditor. The current row in the table is the one I will edit. There will be an Add button to add new rows and a Delete button to delete rows (and fix the dates as necessary to keep things in sync).
There is no single entity to put as EntityToEdit for StandardEditor. On the other hand, StandardLookup is not designed to commit changes.
Is there a best practice to implement this in Cuba 7.2?