Applying changes to multiple rows on submit
I need to implement a functionality where:
SERICE TABLE STRUCTURE
planId | scenarioId | iteration | serviceId (PK)| price
For some service, there are fee details stored in a separate Fee table,
which is structured like this:
planId | scenarioId | serviceId (FK)| rowId | sequence | feeAmount
The serviceId acts as a foreign key linking the fee details to the service. service can have multiple fee detail rows (typically 4), and users can also add new fee rows.
If a user makes changes to the fee details of a service for one plan/scenario combination, those changes should be applied to the same service in other plan/scenario combinations.
We already have a similar functionality for services where changes to the price field can be applied across all combos . Now, we need to do similar thing for fee details. Fee details available for particular service . It can have multiple rows of fee details. users can add new rows of fee details. When a new fee row is added for one plan/scenario combo and the user clicks Apply Changes, that new row should also be added to the fee details of the same service in other plan/scenario combo, Updates existing fee rows across all combos for the same service.
I have challenges to differentiate each rows of fee details and how the newly added row can be appended to other service.
