keep field constantly updated with values from another table even if it changes

cross · 2019-08-14

I am feeding a field with the sum of the quantities of another table, however, I need to know how to keep this field updated if the field of the table that feeds it changes its value? because after it is full and it changes, it does not update.

I still don't have code for this, I just want to know how to perform this procedure or in what way or option it is used.

Resolus · 2019-08-15

What version of Nav/BC are you using?

In my opinion there are 2 options.

1. You could use a flowfield.
This will calculate the sum on the fly and therefor it'll always be correct.
You just need the right filters on the flowfield.
However flowfields might be a bit slower if it's a lot of records.

2. You could work with subscribers.
Create a function and subscribe to the OnAfterModify event of the table from which you want the sum of quantities.
Then in the function you simply put your filters, get the sum and save it into the correct table/record.

But which option is best depends on what you want to use it for/how large the second table is.

This is just my opinion.

Resolus · 2019-08-15

What version of Nav/BC are you using?

In my opinion there are 2 options.

1. You could use a flowfield.
This will calculate the sum on the fly and therefor it'll always be correct.
You just need the right filters on the flowfield.
However flowfields might be a bit slower if it's a lot of records.

2. You could work with subscribers.
Create a function and subscribe to the OnAfterModify event of the table from which you want the sum of quantities.
Then in the function you simply put your filters, get the sum and save it into the correct table/record.

But which option is best depends on what you want to use it for/how large the second table is.

This is just my opinion.

keep field constantly updated with values from another table even if it changes

Best Answer

Answers

Categories