I am using Microsoft Dynamics AX 4.0 and what i would like to do is to filter the records shown in a Grid on my Form. The data shown in the Grid is from the table SalesParmTable. It displays fields ParmId, TransDate and DlvMode.
I only want the records where Ordering = 'Picking list' and SalesId = the SalesId that is selected by the user.
I have tried to write a query (in the textChange method of the field where the user selects the SalesId) to set as the datasource of the grid but i couldn't get it to work.
I am quite the beginner when it comes to programming in X++ so describing every step would be much appreciated.
Thanks in advance