How To enable Find / Filter with function column on TableBox

selece28

Hi All,
I have a problems that gives me a headache...
I create a Form with a TableBox, I set the Form Source Table property = Sales Header. Then i add some columns into the TableBox
But i need the TableBox to display a column which i get the value from C/AL code (example i want to display Salesperson Name)
I add a new column in TableBox and set its property = GetSalespersonName(Rec."Salesperson Code")
With GetSalespersonName is a function in C/AL code.

When i RUN i can see the salesperson name. But i have problems when i want to search or set filter using standard Nav search button(Find, Field Filter, etc).

My question is. Is there anyway so that my salesperson name column can be filtered like the other column in Sales Header?

Thanks in advance

Marije_Brummel

This is not possible with the construction you have chosen.

Alternatively you can make a flowfield for it so you can filter or look in the download section for the Filter on anything on forms. The last one basicaly shows a technique to skip records that are not interesting.

Good luck.

selece28

Flow field means that i should a a column in Sales Header right?
Thanks