>>Hi,
>>
>>this is MM.NET 3.6, but maybe is more general than that.
>>
>>I have an Agents table with an Agent Business Object. I need to display a dropdown list of Agents for the user to select. The Agents' names must be formatted "Surname, Firstname Middlename".
>>
>>Do I:
>>
>>1. Add in a formatted/calculated field to the table and then add this field to the BO?
>>
>>2. Add in a field called FullName to the stored procedures that the BO calls to get the data? Or
>>
>>3. Add in a calculated property on the BO?
>
>Each of these methods should work. For me first two will be simpler to implement, but from the purist point of view I think you should go with #3 as formatting should not be done in the database.
You're right option 1 was dead easy to implement. I'll see if I can get option 3 to work.
Thanks and Merry Christmas