Hi,
I am creating a lookup for a custom field where I want the project Id displayed, along with the Project Stage. The project stage as I see is a method in the ProjTable. Henceforth I am calling the lookup as:
lookup.parmQuery(query); lookup.addLookupField(fieldNum(ProjTable, ProjId)); lookup.addLookupMethod(tableMethodStr(ProjTable,Stage)); lookup.performFormLookup();
the lookup for project id is being generated fine, however for all records the Stage is being displayed as Created. This should not be the case since for the same projects I can see in the All projects that their status is In progress, Finished etc
The above code I have placed in COC of ProjTable using a custom method, which I am calling from the lookup method of the custom field in form. I have used the debugger but got no valuable clue. Any help would be much appreciated. Thanks.
The method depends on the Status field from ProjTable. Does your query include this field?
Ok this works. Thanks!