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
______________
Regards,
Steven
0
Comments
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.
Thanks
Regards,
Steven