Lookup method for Project stage is returning Created for all projects

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.

Parents
No Data
Reply Children
Related
Recommended