ItemId EDT.
The code might look like these :
SysTableLookup sysTableLookup = SysTableLookup::newParameters
(tableNum(InventTable), this);
QueryBuildDataSource qbdsInventTable;
QueryBuildRange queryBuildRange;
Query query = new Query();
;
sysTableLookup.addLookupField(fieldNum(InventTable,ItemId));
sysTableLookup.addLookupField(fieldNum(InventTable,ItemName));
qbdsInventTable = query.addDataSource(tableNum(InventTable));
qbdsInventTable = qbdsInventTable.AddDataSource(TableNum
(InventModelGroup), "InventModelGroup");
qbdsInventTable.addLink(fieldNum (InventTable, ModelGroupId),
fieldNum(InventModelGroup, ModelGroupId));
queryBuildRange = qbdsInventTable.addRange(fieldNum
(InventModelGroup, InventModel));
queryBuildRange.value(queryValue(InventModel::FIFO));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
I think your second question can be solved with similar way.
Regards,
Agus Riyadi
--- In [email protected], "Cenk Ince" <[EMAIL PROTECTED]>
wrote:
> Hi all
>
> I have two questions about lookup,
>
> 1. Is it possible to Run Lookup on a query with two datasources? I
mean that when i lookup inventtable i don't want to see all items,
just items which inventory Model FIFO in InventModelGroup table.
>
> 2. When creating a Production i choose Bomid, i want to see only
active and approved boms. When i override lookup and add range for
active and approved boms, all bom table was there, but i want only
related ones to be seen. How to do that.
>
> Thanks.
>
>
>
> [Non-text portions of this message have been removed]
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.
