205
Hi guys,
I made this custom form, in there i need to make a lookup on red field, based on green field values.
On that form i got a datasource based on a custom table, where i have a field linked to bankaccount table on accountID (Red field) and another linked to data aread id (green field)
The red field will give on each row bankaccount accounts filtered on green field values representing data areas.
I hope my requirement is understoodable.
How could i perform that ?
Thank you all.
We can use addCompanyRange but you can't say that legal entity is static. If there is any new legal entity added and new bank account added against the company, you need to modify the code also.
You can use that as workaround but need to keep in mind of the above drawback.
Thanks,
Girish S.
Please check this article, instead of query range use company range.
You want the query based on some other dataareaid which is not the UI dataareaid right. So you should use change company. Just check the same in inventtable or vendtable for example.
Give changecompany and in that write this query.
Can you change datasource property cross company query to Yes and check.
I think you need to have a query.allowCrossCompany(true) and then set the "Cross-company auto query" property to yes at form DataSource level.
If it doesn't suit your scenario try creating cross company query with BankAccountTable as DataSource - Create a AOT view - Map that query to a view - Use that view in the lookup query instead of BankAccountTable.
Thanks,
Girish S.
Share
Report
All responses (
Answers (
public void lookup(FormControl _formControl, str _filterStr)
{
//Specify the name of the table the lookup should show data from.
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(BankAccountTable), _formControl);
//Create a new query
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
sysTableLookup.addLookupfield(fieldNum(BanAccountTable, AccountId));
//join the datasource to the query;
queryBuildDataSource = query.addDataSource(tablenum(BankAccountTable));
queryBuildDataSource.addRange(fieldnum(BankAccountTable, DataAreaId)).value(queryvalue(DataSourceName.DataAreadId));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
I was saying that its working with that code, but i got an error notification saying :
Your question is not actually understood. Can you please explain in more detail so that I can give my solution approach if possible?
Can you try removing the line query.allowCrossCompany(true) from your code.
If removing this line does not work then try this code on Form control (in FOrm Design) lookup instead instead of form datasource field lookup.
#1
André Arnaud de Cal...
291,861
Super User 2024 Season 2
#2
Martin Dráb
230,540
Most Valuable Professional
#3
nmaenpaa
101,156
