
Hi I'm fairly new at X++ and MorphX and I'm trying to add a field in the InventOnHandListPage.
That field is a Inventory status located in a seperate table that has a InventDimId foreign key. I have added a field to the grid and created a display datamethod in the Form. My goal was to use a select statement on each line of the grid to get the status i want to add. The issue with this is that I don't know how to get the InventDimId i need to get that status (for each line).
I also tried to modify the query used in that form and add a innerjoin on the InventDimID to be able to add my required field. Using this I couldn't get to add the field in the Form's grid and I would break the query (nothing would display anymore)
Can someone help me with what would be the best approach?
Thank you,
Julien
*This post is locked for comments
I have the same question (0)you shoul create display method on the table using which that listpage is developed,
use that display method as one of filed in the list page grid
Please validate