Flowfields or variables?

poppins

Hi everyone,

I have to display some fields in a page that are coming from another table.
What is the better/cleaner solution? Add the fields as flowfields in the table and just show them in the page? or add them as variables directly on the page?
The fields do not require any calculation, just showing names and bank details...

Thanks in advance

mohana_cse06

if the no. of flowfields on page are less then I prefer folowfields

Slawek_Guzek

If the table is a sort of history/ledger type, where I should show the data as of when the record has been created then I am creating normal fields un a table and populate them accordigly.

If I need something which shows me the current state of master data then I am using flowfields. Thats my basic rule of thumb.

In my view flowfields are generally better as they let me avoid coding to keep fields synchronised, and also are saving a bit of the databasew space - at the cost of performance.

Coding on a page is my least favourable technique as it generally performs a tad slower that the flowfields (as in new NAV flowfields are calcuated by the SQL Server not the client), and user cannot sort or filter on a calculated field.

My £0.01

Slawek