Need to diplay foreign value SF Combo control


Author
Message
Michael Reese
Michael Reese
Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)
Group: StrataFrame Users
Posts: 235, Visits: 1.6K
I have combo control for displaying Personnel Table

Personnel Name

Position Title

I need to display the related position title name from the position table instead of position title in the Personnel Table. I am successfully doing this in a listview. However, I need to do this in a combo.

Thanks

Michael

Private Sub VendorContacts_RowPopulating(ByVal e As MicroFour.StrataFrame.UI.Windows.Forms.RowPopulatingEventArgs) Handles VendorContacts.RowPopulating

e.Values(2).DisplayValue = BoPositionTitles1.GetRecordName(CType(e.BusinessObject, ORION_BO.BOVendorContacts).PositionTitle)

End Sub


StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
You can accomplish this by changing the method you use to gather the data for the combo box to join in the appropriate column from the other table.  When you specify the display fields in the PopulationDataSourceSettings, you can manually type the name of the column (for cases like this, when a column comes from another table that the designer doesn't know about). 
Michael Reese
Michael Reese
Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)Advanced StrataFrame User (533 reputation)
Group: StrataFrame Users
Posts: 235, Visits: 1.6K
I think I understand you however, I created a view and configured my Combo to execute display position titles. The sp executed when the form loaded which was too soon. No data displayed. Do you have an example or any further suggestions?

Thanks Much!

StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
You could possibly move the code to fill the business object to the ListPopulating event handler of the combo box.  You can then change when this event gets fired by chaning the InitializationPriority property on the combo box to position it relative to other objects that require initialization (business objects, other lists, etc.)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search