Subject Re: on_navigate with mastersource and masterfields why diffrence
From Mervyn Bick <invalid@invalid.invalid>
Date Fri, 10 May 2024 17:42:55 +0200
Newsgroups dbase.getting-started

On 2024/05/09 23:16, Dirk C wrote:
> hello to you,
> a explanation needed
>   when i use this query with masterfields, rowset_onnavigate is working
>   well
>   but if i use mastersource the rowset onnavigate is following aswell but!
> only one step later,

I can see what is happening and the work-around is to add a requery for
VRAAGBAK_AFMETING in the onNavigate event handler.

function rowset_onNavigate1(type, nRows)  // vraagbak_crossen
     this.parent.parent.DOOS_AFMETING.KNOP_AFMETING_INGAVE.visible = true
      ?"test true"
    this.parent.parent.DOOS_AFMETING.KNOP_AFMETING_INGAVE.visible = false
      ? "test false"

It does, however, look as if you are doing something that is most
unusual.  Mastersource is usually used to fetch many records from the
child table where a field in the child table contains the same value as
the value in a single record of the parent table.

Even though there may be many matching records in the child table, your
onNavigate event handler for the parent query will only ever look at the
first of possibly many child records.