I have a written code for lookup as and when i select a account type, ie., when i select a value from combo, automatically the lookup of that account type is displayed, but only account type and name are displayed in that.
My code is some what like this:
void lookup()
{
Ledgertable LedgerTable ;
CustTable CustTable;
SysTableLookup SysTableLookup;
queryBuildDataSource queryBuildDataSource;
queryBuildRange queryBuildRange;
Query query = new Query();
;
if ( LedTable.AccountType == LedgerJournalACType::Ledger)
{
SysTableLookup = SysTableLookup::newParameters(tableNum(ledgertable), this);
sysTableLookup.addLookupField(fieldNum(ledgertable, accountNum));
sysTableLookup.performFormLookup();
queryBuildDataSource = query.addDataSource(tableNum(ledgertable));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(ledgertable, accountNum));
sysTableLookup.parmQuery(query);
}
else if ( LedTable.AccountType == LedgerJournalACType::Cust)
{
SysTableLookup = SysTableLookup::newParameters(tableNum(CustTable), this);
sysTableLookup.addLookupField(fieldNum(ledgertable, accountNum));
sysTableLookup.performFormLookup();
queryBuildDataSource = query.addDataSource(tableNum(CustTable));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(CustTable, accountNum));
sysTableLookup.parmQuery(query);
}
else if ( LedTable.AccountType == LedgerJournalACType::Vend)
{
SysTableLookup = SysTableLookup::newParameters(tableNum(VendTable), this);
sysTableLookup.addLookupField(fieldNum(VendTable, accountNum));
sysTableLookup.performFormLookup();
queryBuildDataSource = query.addDataSource(tableNum(VendTable));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(VendTable, accountNum));
sysTableLookup.parmQuery(query);
}
else if ( LedTable.AccountType == LedgerJournalACType::FixedAssets)
{
SysTableLookup = SysTableLookup::newParameters(tableNum(LedgerTable), this);
sysTableLookup.addLookupField(fieldNum(LedgerTable, AccountNum));
sysTableLookup.performFormLookup();
queryBuildDataSource = query.addDataSource(tableNum(LedgerTable));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(LedgerTable, AccountNum));
sysTableLookup.parmQuery(query);
}
else if ( LedTable.AccountType == LedgerJournalACType::Bank)
{
SysTableLookup = SysTableLookup::newParameters(tableNum(BankAccountTable), this);
sysTableLookup.addLookupField(fieldNum(VendTable, accountNum));
sysTableLookup.performFormLookup();
queryBuildDataSource = query.addDataSource(tableNum(BankAccountTable));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(BankAccountTable, AccountID));
sysTableLookup.parmQuery(query);
}
else if ( LedTable.AccountType == LedgerJournalACType::CostAcc)
{
SysTableLookup = SysTableLookup::newParameters(tableNum(LedgerTable), this);
sysTableLookup.addLookupField(fieldNum(LedgerTable, AccountNum));
sysTableLookup.performFormLookup();
queryBuildDataSource = query.addDataSource(tableNum(LedgerTable));
queryBuildRange = queryBuildDataSource.addRange(fieldNum(LedgerTable, AccountNum));
sysTableLookup.parmQuery(query);
}
else
super();
}
Now when i select a number in lookup form and click the button, that has to display the form from where the value comes..and that value should be higlighted or shud be first.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
