Could anyone shed some light on why using drag and relate from a user query is not working for me?
Drag and relate works well from all system generated queries, but not from my user queries.
- System query/report - running a system stock report and dragging the 'Item number' field result to a D&R Sales Order generates a report of all Sales Orders for the selected Item Number. As expected - success.
- User Query - running a item lookup report from a user generated query and then D&R to Sales order for the selected Item Number does not work. Error = 'No matching records found (ODBC -2028) [message 131-183]