Hi Friends,
I am totally new to Microsoft Dynamics NAV and presently in a learning stage (NAV 4.0 SP1).
I am having a problem in creating a drill down functionality in a table.
Let me 1st describe the situation. I have a Master table with 3 fields Code, Name and Total Sales. Total Sales is a flow field. I have another table called detail with two fields code and sales amount. The code field has a relation with Master table and the lookup functionallity is working fine. Also the Tatal Sales FlowField in the master table perfectly displays the code wise Total Sales value present in detail table.
The problem is, whenever I am clicking the Drill Down Button corresponding to the flowfield in the Master table, it is not working. I want to get the code wise detalis just like the Balance field in Customer table.
Things that I have done:
1. I have created two list forms each for two tables. The drill down is woking fine in the form for Total Sales Value (though I cant manage to filter for code wise details)
2. Have specified the Detail List form in the DrillDownFormID property of the master table.
3. I found that there is no OnDrillDown trigger in a table.
Friends plz tell me the right way. I know that this is a pretty basic issue, but still consider me as I am a novice in Navision.
Thanks in advance
0
Comments
and do you have set the DrillDownFormID in your Detail Table where the sales values are stored and from where the FlowField get his values?
Regards
The only way to make it work by table properties is to remove ALL code and local variables from all drilldown triggers that belong to the flowfield.
RIS Plus, LLC