At the top level of my site collection, I have created a list called "Markets", and a site column called "Market", defined as a lookup to the Markets list.
In a subsite of this same site collection, I have a list called Projects, where I have included the Market site column.
I am now trying to retrieve the Title and Market information from the Projects list using REST services. The following triggers an error:
http://site/subsite/_vti_bin/listdata.svc/Projects?$expand=Market
What am I missing?
[Edit] Clarification: the point is that the above notation works perfectly when the lookup list is in the same site as the Projects list. My issue is only related to site columns, where the source list for the lookup is at the top level.