Share
Report
725Hello,
The business requirement is this: I need to add some fields from SalesLine and from CustTAble, resulting from a sales order, to InventOnHandItem forms.
These fields must be sortable and filterable, so display fields are not an option.
These fields must be sortable and filterable, so display fields are not an option.
I found an article on how this can be with views: https://14-dynamics365.com/2021/07/28/how-to-create-a-filter-on-display-method-using-view-d365-fo/
So I created a view with salesLine as the main data source and put it as an additional data source in the InventOnHandItem form and insert InventDim as join source:
I then created a relationship with my view in the InventDim table:
After adding fields from salesLine, only the value on the first record is visible. The rest are empty.
In addition, the rest of the records are duplicated. My guess is that this is the fault of a bad relationship between the table and the view.
In addition, the rest of the records are duplicated. My guess is that this is the fault of a bad relationship between the table and the view.
Could someone suggest what relationship settings would be correct for my problem?
All responses (
Answers (
