I have two fields in form one is with lookup string field and other is string type blank field ,in lookup drop down it shows "Product Number" and "Search Name"
if I select "Product Number " "0001" from product Number field it should automatically populate "Search Name" to my "Product Name" field.
Below pictures will elaborate what i am trying to say.
.
Girish,
such a nice person you are.
how many times do i have to thank you ?:)
This is because "CHI" county belongs to CHE country region. To get description you have added code based on the country region particularly to USA.
But generally, county will be used along with state and country region id.
To fix this issue we can convert that to select statement and add only county id in where condition. But there will be same county exist for multiple states and country regions.
I suggest you clarify this with functional after changing it like below.
LogisitcsAddressCounty addressCounty; select firstonly * from addressCounty where addressCounty.CountyId == this.CountyId; this.CountyName = addressCounty.name;
Thanks,
Girish S.
here is my problem ,
in lookup it shows me country names from every country/region, but displays only "county" and "Description" from country/region "USA"
as i have clicked on "CHI" it only displayed county but description is empty.
i want it to display for every region But not not specified for USA.
If the lookup is from EDT then it will show all the county Id irrespective of the country region id.
Normally county Id lookup will be based on the selection of country region id and state. You can refer to standard address creation form for customer - vendor - worker.
Thanks,
Girish S.
Girish,
I have added string type field to my table and set its EDT to "LogisticsAddressCountyId",
so it is coming from EDT.
thanks
How you write lookup for county Id? Or the lookup is coming from EDT?
Thanks,
Girish S.
then how specificialy I have to do it ?
I have tried my knowledge but it didn't help.
It depends upon how you have added lookup for County Id. If you don't add any range to country region, then it will display against all country regions.
Thanks,
Girish S.
This is acceptable and it is working . but what if I have to show data against every region , now it is just showing data against USA region.
Oh, sorry I wrongly typed the EDT name. It is LogisiticsAddressCountryRegionId.
Thanks,
Girish S.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156