
In TB00/Procurement and sourcing/Journal/PriceDiscountAgreemnetJournals/Line Form
New field with Customer Address lookup based on CustomerAccount Selction in another field.
Please help me ASAP .
Thanks in Advance.
*This post is locked for comments
I have the same question (0)override the lookup method on that field and put the following code
Query query = new Query();
QueryBuildDataSource dsDirPartyPostalAddressView;
// Instantiate sysTableLookup object using table which will provide the visible fields
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(DirPartyPostalAddressView), _formControl);
;
// Create the query
dsDirPartyPostalAddressView = query.addDataSource(tableNum(DirPartyPostalAddressView));
if(_customerAccount)
{
SysQuery::findOrCreateRange(dsDirPartyPostalAddressView ,fieldnum (DirPartyPostalAddressView,Party).value( CustTable::find( customerAccount).Party)
}
// Set the query to be used by the lookup form
sysTableLookup.parmQuery(query);
// Specify the fields to show in the form
sysTableLookup.addLookupfield(fieldNum(DirPartyPostalAddressView, Address));
// Perform the lookup
sysTableLookup.performFormLookup();