Dynamics Community Forum Thread Details

ProdTable Form error

I have a customer that needs particular information from the Item Master (InventTable) to be shown in the grid for each production order on the ProdTable form. I have added the InventTable datasource to the form, and set the relation of InventTable to be related to ProdTable on an innerjoin. When I open the ProdTable form, the form displays all of the appropriate information properly. However, when I go to the SalesTable form and either perform the "Inquiry > Production" on a sales line, or right-click the reference number field on the other tab (production order), when the ProdTable form is opening, it throws and error that looks like it is coming from the kernel in regards to the query. Specifically:

(C)\Classes\QueryRun\setRecord

(C)\Classes\FormDataSource\executeQuery

(C)\Classes\FormDataSource\linkActive

(C)\Classes\ProdTable\Data Sources\ProdTable\Methods\linkActive - line 89

However, if I change the join type from innerJoin to either Passive or Delayed, the linkactive works, but the data does not show from InventTable when I open the ProdTable form directly.

Any help would be greatly appreciated.

Thanks,

Joe

Quick Links