bussiness rule for updating a change that happens in one table to other table

[Community Alums]

bussiness rule for updating a change that happens in one table to other table

[Shaik Ibrahim k · Accepted solution]

Insert/update BR on Table A

[Sagar Pagar]

Hi @Community Alums,

Can you explain your complete requirement here?

Thanks,

Sgara Pagar

[Community Alums]

I have Table A with Product and quantity field, each time when quantity gets updated or new record is inserted in Table A, the quantity field should be summed up based on same product.

The summed up quantity should be updated in other table field say Table B's total quantity field.

[anishsasi]

Write a business rule on Table A by summed up based on same product. 

Write a script on Table B to update the summed up quantity field.

[Raheem Pp]

If I understand your requirement correct, I think you need to update Table B on update of table A records, right?

If that is the case - write a BR which gets triggered on table A, then write a script here in the BR to update the records in table B.