I love the improvements in SP 2010, especially list relationships. However, I am struggling with some of the limitations. It seems that after you create a lookup field into another list (parent list), only some columns from the parent list are available
as Projected Fields. The following column types are not available to be "projected":
- Calculated fields
- Choice fields
- Lookup fields into yet another list
I must say, I do not understand why these limitations exist. Let's take "Choice Fields" as an example. Basically a text field with a limited set of options at the time of data entry. There should be no technical reason why you cannot project such a field.
Now, that I have to find a different way of getting these types of fields projected into my "joined" view, I tried using SPD. Theoretically, there is a "Linked Data Source" that should allow for a JOIN of 2 or more lists. Unfortunately, it does not seem
to work with SP Lists:
- The Data Source Wizard does not allow you to match columns - one from each list (a.k.a. foreign key). That does not worry me, because the lookup field itself provides this information implicitly, but it's noteworthy.
- Once the Linked Data Source was created, projected fields were filled but th
View Complete Post