Hi
Experts,
I need
to display rows from the header table VendPackingSlipJour, where by the
warehouse field in the related chilid table, VendPackingSlipTrans, equals
to "ABC".
This is the codes that I had came up
with:
this.query().dataSourceTable(tableNum(VendPackingSlipJour)).addDataSource(tableNum(VendPackingSlipTrans)).addlink(fieldNum(VendPackingSlipJour,InternalPackingSlipId),fieldNum(VendPackingSlipTrans,InternalPackingSlipId));
warehouseCriteria =
this.query().dataSourceTable(tableNum(VendPackingSlipTrans)).addRange(fieldid2ext(fieldNum(VendPackingSlipTrans,
Dimension),3));
warehouseCriteria.value("ABC");
warehouseCriteria.value("ABC");
However, I notice that the header rows (VendPackingSlipJour) duplicates,
according to the number of result rows from the child
table (VendPackingSlipTrans). I realise this is because of the child
datasource that have been added to the query. Is there any way to code this
search criteria and prevent the header lines from duplicating?
TIA,
Charles
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
