How to calculate field for each record in the page without creating a new field in the table?

zaidtariq

I want to have a new field "Source Name" added on the page. This field must be "calculated" for each record in the Page using "Source Type" and "Source No.":
While "Source Name" must only exist in the Page - do not create a new field in table

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

Kishorm

Create a variable, add to the page, add code in OnAfterGetRecored trigger to calculate and set the value of the new variable.

bbrown

Alternate solution: Add function(s) to the source table that calculate and return the needed values.

Advantage: Functions are reusable elsewhere.