Is there any way I can get field ID of current record which is currently active.
*This post is locked for comments
CurrFieldNo specifies the field number of the current field
It is not working on Page. Does it work only on table.
yes, it works in tables.
Please check whether you can move same code to a function table and call it from page
I made a following function in table and called it from page. All the filters are flowing good on page except "Field No.". Filter on "Field No." is always 0 . Means CurrFieldNo returning 0 evrytime.
TestRec.RESET;
TestRec.SETRANGE(Code,Code);
TestRec.SETRANGE("Field Type","Field Type");
TestRec.SETRANGE("Line No.","Line No.");
TestRec.SETRANGE("Field No.",CurrFieldNo);
PageTestRecList.SETTABLEVIEW(TestRec);
PageTestRecList.LOOKUPMODE(TRUE);
IF PageTestRecList.RUNMODAL <> ACTION::Cancel THEN;
Where did you call the function from page?
On subform .from OnAction trigger of ActionItems
Hi all,
Just make a test in OnModify trigger of table, it always shows 0 :-(
OnModify()
MESSAGE('%1', CurrFieldNo);
Make sure that you have written code in proper place and not in action.
you can write in field triggers like Onvalidate etc
I need to simply apply filters and lookup the corresponding page .Writing code on Onvalidate trigger will not apply filters or lookup page. I have around 50 fields in table .on which field or how shall I write code on On validate Trigger.
Thank Mohana for your information!
It works in field Onvalidate trigger, but it is much work to write code for each fields, totally agree with NavTech!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Alexander Ermakov 2
SC666 1
