LookUp on Form Grid Control?

Finance and Operations/AX Technical Forum
1

Hi All,

I have created one StringEdit Control on PurchTable Form’s General Tab.

I want to show “Received Transfer Orders” in this stringEdit control as lookUp and allow user to select particular Transfer Order for current Purchase Order.

I have override lookup method as below.

public void lookup()

{

Query query = new Query();

QueryBuildDataSource queryBuildDataSource;

QueryBuildRange queryBuildRange;

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(InventTransferTable), this,true);

;

sysTableLookup.addLookupfield(FieldNum(InventTransferTable,TransferId),true);

sysTableLookup.addLookupfield(FieldNum(InventTransferTable,InventLocationIdFrom),false);

sysTableLookup.addLookupfield(FieldNum(InventTransferTable,InventLocationIdTo),false);

queryBuildDataSource = query.addDataSource(TableNum(InventTransferTable));

queryBuildRange = queryBuildDataSource.addRange(FieldNum(InventTransferTable,TransferStatus));

queryBuildRange.value(enum2str(InventTransferStatus::Received));

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

}

It works for me BUT when i select one of the available Transfer Order it fill up against all the available Purchase Orders.

How to associate this Selected Transfer Order to Current Selected Purchase Order?

Thanks & Regards,

Mehul Thacker

2

You should propably need an edit method here…(As the string Edit is not bounded)

3

Hi Kranthi,

What should i write in edit method??

code to lookup value

OR
code to assign value to table field which is selected from lookup!

Thanks & Regards,

Mehul Thacker