I have a BrowseDialog properly configurated and working fine.
My question is if it's possible show a value in one column that comes from another related table.
Example:
I have a Countries table and a States table, each one has a unique ID and a text field, in the states maintenance form I add a BrowseDialog and add two search fields, one is a combo that retieves the names of the countries and another a text box for the name of the states.
Both works fine. What I want is in the list result, I want to show the name of the country because actually has the ID and the name of the city.
Thanks in advance for your valuable help.
Regards Everything is possible, just keep trying...
What I want is in the list result, I want to show the name of the country because actually has the ID and the name of the city.
Regards
Hi Juan Carlos,
Sure you can. In the main StatesBO create a Custom Property CountryName, this property will have code to get the country name based on the StateBO.CountryFK, then in the Dialog Browser add the CountryName property to be shown in the ListView. Of course, first re-build the BO library project or the solution so the new property will show up in the designers.
Here is a sample pseudo code that will get you started...
{
<Browsable(
BusinessFieldDisplayInEditor(), _
Description(
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _
loLookupBO.FillByPrimaryKey(
There are a lot information about Custom Field Properties in the help file and in these forums, so please check it out for better technical understanding. This is just another feature I fall in love to