How To enable Find / Filter with function column on TableBox

selece28
selece28 Member Posts: 316
edited 2007-04-20 in NAV/Navision Classic Client
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

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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.
    Marije Brummel | Freelance Business Central Specialist
  • selece28
    selece28 Member Posts: 316
    Flow field means that i should a a column in Sales Header right?
    Thanks
    ______________

    Regards,
    Steven

Categories