44
Hello,
I have a custom Form with two Foreign keys ProdRoute.OprId and RouteCostCategory.CostCategoryId which I am linking toghether in the custom table as well. I just want to modify the standard lookup field for the EDT RouteCostCategoryId to add the Description of that cost category which is in the Share Categories table (SharedCategory.CategoryName)
Even better make a copy of the EDT and then modify it so it can show the CategoryName
Thanks a lot!
Hi Sergei.
mmm ok. so no straight copy code for standard lookups. I already tried sysTableLookup I think I know how to handle it. I thought the lookup where EDT-related or something like that.
Anyway thanks for your help I will set this thread as Solved. Thanks a lot!
Hi CBNestor,
Yes, in this case you need to use sysTableLookup class and lookup method on form datasource field. Check InventLocation.lookupBySiteId method and how it's used.
Hi Sergei,
I know what you mean, Yes now I am change the Standar lookup field. I can show the all 3 fields now. But if I want to leave the standard lookup as it is. I make one on my own. So I can show the 3 fields just when and where I want to. Is it possible to make some kind of a copy and customize from that copy?
Hi CBNester,
You need to add fields CostCategoryId and CostGroupId to the field group as well.
No the CostGroupId is gone. Thats why I wanted to make some kind of copy of the lookup, customize it and the use it in my custom form. I dont want to change the whole Lookup in whole system
Hi CBNestor,
Just drop needed fields to the group (from fields node) and display method from methods node.
Hi Sergei,
I have the display on RouteCostCategory. I dont see any fields in the RouteCostCategory AutoLookup fGroup. how to add that. thank you
Display CategoryName GetCategoryName()
{
SharedCategory _sc;
select CategoryName from _sc
where _sc.CategoryId == this.CostCategoryId;
return _sc.CategoryName;
//return _sc.find(this.CostCategoryId).CategoryName;
}
HI CBNestor,
As mentioned, the display method should suit your needs.
You need to check how the lookup of the Category field is implemented, only add another field. please check this thread for the logical method.
#1
André Arnaud de Cal...
291,642
Super User 2024 Season 2
#2
Martin Dráb
230,371
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
