Filter Subform2 By data in Subform1

love2courtney
love2courtney Member Posts: 16
in NAV/Navision Classic Client
Hi there,
I need to add 2 subform into a main form. I then need to filter one of them with data stored in another subform (Something like subform link). Is there any chance to do that? I'm not able to do it.

Many thanks.

Answers

  • love2courtney
    love2courtney Member Posts: 16
    On nav 2009
  • Jan_Veenendaal
    Jan_Veenendaal Member Posts: 206
    You can only do so by code, and you will probably need to use a timer to (e.g. every second) to get changes form subform1 and set (if something was changed) new filters on subform2.

    Be aware that this (a) might easily create performance and locking issues, and (b) that forms using a timer are hard to debug.

    In many cases there are other (better!) solutions to this issue, most preferable a different design without dependencies between subforms.
    Jan Veenendaal
  • love2courtney
    love2courtney Member Posts: 16
    Jan_Veenendaal wrote: »
    You can only do so by code, and you will probably need to use a timer to (e.g. every second) to get changes form subform1 and set (if something was changed) new filters on subform2.

    Be aware that this (a) might easily create performance and locking issues, and (b) that forms using a timer are hard to debug.

    In many cases there are other (better!) solutions to this issue, most preferable a different design without dependencies between subforms.

    I got your point. Thank you.

Categories