In Item table, ItemType is a option field with option values A,B,C
I want to filter ILE in OnOpen form, of Item Type A. I don’t want to add Item Type field to ILE
There are ways...
But you'll need to loop your entries and either Mark your records or copy your records to a temporary record variable and open the form based on that.
Each solution has pros and cons.
In both cases, too many entries would slow you down...
In Item table, ItemType is a option field with option values A,B,C
I want to filter ILE in OnOpen form, of Item Type A. I don’t want to add Item Type field to ILE
You basically have to GET the Item and do a currreport.skip if the conditions are met.
I highly recommend that you save yourself the headache and just create a field or a flowfield to filter on.
I think Temporary record on form will do since you don't want to add a field on ILE,Use the SourceTableTemporary properties and insert the records when met your filters.
Definitely add the field. Your solution, to get the item, then mark the ILEs or put them in a temp table, is going to take longer and longer as your item master grows.
It's a pretty simple modification to add the field / flowfield to the table.
Answers
Why? :-k
There are ways...
But you'll need to loop your entries and either Mark your records or copy your records to a temporary record variable and open the form based on that.
Each solution has pros and cons.
In both cases, too many entries would slow you down...
From where do you open the form?
PS: I would add the field...
You basically have to GET the Item and do a currreport.skip if the conditions are met.
I highly recommend that you save yourself the headache and just create a field or a flowfield to filter on.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
be smart before being a clever.
It's a pretty simple modification to add the field / flowfield to the table.
My Blog - nav.education