Hi,It has been a while since I wrote any new blog entries because I got married J and guess what l am the luckiest man on earth with my wife and also I have reallocated my job from Estarta - Jordan to Injazat Data Systems - UAE (a joint venture between Mubadala and EDS) so my hand were little bit full.Anyways I decided I will update my blog with a series of entries to recap my absence and as a start I noticed something very strange in SharePoint lists lookup fields, I was doing a presentation for a client to show the ability of getting data from other lists and my example was to retrieve data from team members list that had two columns as the following:1- Title by default with the list of type single line of text2- Team member name of type people and groupMy goal was to connect the column to the team member column and guess what! It did not show up in the drop down list so as a result I made a small exercise to see what are the columns that are supported by the lookup column:
| Column Type |
Supported/Not Supported |
| Single line of text |
Supported |
| Multiple line of text |
Not |
| Choice – Drop down list |
Not |
| Choice – Radio buttons |
Not |
| Choice – Checkbox |
Not |
| Number |
Not |
| Yes/No |
Not |
| Person or Group |
Not |
| Hyperlink |
Not |
| Hyperlink – Picture |
Not |
| Calculated |
Supported |
I know there are other solutions to get the values of these columns like the DVWP but is there any reason behind this limitation because I recall some of these columns were supported by SharePoint 2003.
Enjoy
Yazan