Situation : table Formwed , fields are PLT and PLU etc…
Made a view namely vwvgtoza with the fields naamvoor , club,lidkaartnr.
In lookup tabe, (child lookup fields) linkfield = naamvoor and I do an Auto fill of club and lidkaartnr.
In the Filter option of child lookup fields I want to use the field club of my viewvgtoza to see only the names of field PLT (table Formwed).
This works for example "CLUB = ‘GMB’ "but of course my intention is to use the value of PLOEGT or PLOEGU.
"CLUB = ‘$ this-> PLT-> CurrentValue’ ". Unfortunately this does not work.
Can anyone help me with this …thx
Actually it is not my intention to do auto fill from a field. My Lookup table shows all members to make a choice.
In my edit table Formwed, the name of the home team (PLT) is a fixed value also ( PLU) . When i do a login ,i get the record that i want to edit.
Lookup table filter makes it possible to make a selection,the goal is to see only a selection of members of that club.
So I am actually trying to adjust the CLUB field (from lookup table) with field (PLT or PLU) from Formwed table.
Is that possible .
I very much appreciate your patience. thx
You better see the tutorial on Dynamic Selection Lists in the help file.