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

Best way to reporesent a foreign key

In your Dialog example -
You display an "Employee ID" column with a numeric editor.
Let's assume this a foreign key value to an employee table.
The numeric editor is insufficient because a value can be selected that does not exist in the employee table.
What is the best way to represent a foreign key in the grid [display and editing]?
I have seen the drop down data source, which works for editing, but fails for displaying because the Id is still shown in the grid, rather than the display text [in this case, it could be the employee's name].

3 Replies

BM Bala Murugan A.S Syncfusion Team October 11, 2013 05:22 AM UTC

Hi Jeremy Branham,

Thanks for using Syncfusion Products.

We have created a new Direct Trac incident 114223 for you query and updated response in that incident. We suggest you to followup that incident for any further assistance.

Please let me know if you have any concerns.

Balamurugan A.S

SM Suchayna Metra May 11, 2014 02:42 PM UTC

Any update on how to show foreign key values on the MVC grid?

HJ Hariharan J V Syncfusion Team May 19, 2014 11:55 AM UTC

Hi Suchayna Metra,

Thanks for your udpate.

We have response for the query("Any update on how to show foreign key values on the MVC grid") in the incident 125217 and we suggest you to followup the incident 125217.

Please let us know if you need any further assistance.

Hariharan J.V

Live Chat Icon For mobile
Up arrow icon