Its good that we have a Lookup_Selecting($fld, &$filter) where we can add our own lookup filter condition.
BUT its not good enough, coz the more we use it we realise that we would like to customise more than just the condition.
Sometimes when we get to that point we know what the sql is supposed to be like, but we ust can impliment it since the lookup is directly linked to some fixed sql expresions from a certain table or view, or we can use a given table/view coz we want the sql to be dynamically generated
, so it would be nice if we have an event where the sql select statements used during lookup are exposed for edit.
That way we would be able to pass our own more dynamic select statement, ofcourse specifing which is the link field, diaply fielda, ddisplay field 2 etc etc.
I feel that would make the powerfull lookup fucntionality in phpmaker to be even more usefull