We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

One to many relationship, how to display/select

Given the following example what would be the best way to handle the given data in a single databound grid. There are two main entities: users and hobbies. I would like a grid listing all users with some column in the grid displaying any hobby the user is interested in, where the user can select multiple entries. There are three data tables involved, a user, hobby and user_hobby_map table. I was thinking some type of drop down grid or grid list with multi-select. But I can't seem to find the right combination. Any suggestions or hints as the best way to handle this using your grid control? Is there already a sample out there showing something like this that I could look at?

3 Replies

AD Administrator Syncfusion Team January 2, 2003 08:37 PM UTC

Hi Chuck, take a look at message http://www.syncfusion.com/forums/message.asp?MessageID=1313. Kai Iske has a multi-select combobox that you could use. If, on the other side, you prefer to show each hobby in its own row and you want the table be grouped by user you should check out the DataBound\Hierarchical\ExpandGrid sample project. Stefan

SA socrates anibal rivera rivera replied to Administrator June 10, 2022 12:34 AM UTC


I have the same question.

The link you suggest is broken, can you correct it?

Thanks in advance,


Socrates A Rivera R

DM Dhanasekar Mohanraj Syncfusion Team June 10, 2022 02:42 PM UTC

Hi Socrates A Rivera R,

Please find the valid link here,

Forum link: https://www.syncfusion.com/forums/1313/currency-input-type-cell-type,

Please check this and revert us if you need further assistance for this.

Dhanasekar M.

Live Chat Icon For mobile
Up arrow icon