Hello,
What logic should apply to filter out records in a select field, in the details section of a master-detail page.
I'm in insert mode, I assume that the details section is in "gridadd" action.
The thing is I do not want to filter out the record with CurrentPageID == "list", as the records should be visibile in grid-list, only if I'm in insert/grid-add mode.
this condition is not filtering out the records (in Lookup_Selecting):
string sFilterLookup = "";
if (fld.Name == "FiledName") {
if ((CurrentPageID() == "add") || ((CurrentPageID() == "list") && (CurrentAction == "gridadd"))) {
sFilterLookup += "[Hidden] = 0";
}
fld.Lookup.UserFilter = sFilterLookup;
}