Is it possible to add extra where clauses for a detail table when we link master detail via where clause
Currently we use this to link
DetailTable.MasterSource:=Self.DataSource;
DetailTable.MasterMappingMode:=mmWhere;
DetailTable.MasterFields:=MasterFields;
DetailTable.DetailFields:=DetailFields;
We want to add some extra (predefined) where clauses
e.g pnm_nederlands=1 AND pnm_hoofdnaam=1
Already tried this but it does not appear to work
FPrijsZettingDetailJoinedTable.MasterRequestMappings.Add(fld_PrijsZettingprz_primkey+‘=’+fld_PrijsZettingDetailJoinedpzd_prz_primkey);
FPrijsZettingDetailJoinedTable.MasterRequestMappings.Add(‘pnm_nederlands=1’);
FPrijsZettingDetailJoinedTable.MasterRequestMappings.Add(‘pnm_hoofdbenaming=1’);
FYI: I also tried putting constants in the table.MasterFields property (comma separated) and the actual fields in the Table.DetailFields property but this fails too (constant 1 not allowed)
this is a bit outside of my own scope, and unfortunately, my colleague Eugene who is best to answer this is off this week, but je gave me this suggestion>
He should apply the usual dynamic where to detail table like