OK I think I can explain my second paragraph a little better now... Here's a picture to help:
As you can see in the grid above the user edit form page you'll see a "2" in the first column, after the "edit" column... Also on the Details page, you'll also see a "2" in the top textbox... In my first paragraph, I'm asking on how to display either "Integer" or "String" in the first cell instead of a "1" or "2", the values of "Integer" and :"String" come from the related table (SettingType)... Now for my second paragraph... In the User Edit form/detail page... I would like to have a dropdownlist instead of that first textbox for the SettingType field... What's stored in the (Setting) table is a "1" or a "2" and so on based on the type, but I would like to have the user choose from more human meaningful values of "Integer", "String", "Boolean" and so on... these values will come from the related table... As in this particular example, it is my goal to allow the user to go in change the incorrect settingtype of "2" to be the correct type of "1" but have them really choose from the dropdown containing "Integer" , "String" , "Boolean" and what not...
So my BIG question is that on the detail page, the dataitem on the page contains the datarow from the settings table, with the SettingType integer field of 1's ,2s,3,s and so on. but I would like to present the user with "The readable values to choose from. which is in the related table... I'm NOT editing the related table, just using values from it for presentation. So is there an easy way to get to that related table via the dataitem that is a datarow from the main table????
Thanks in advance,