I'm following the steps in this article to setup a joined data view webpart joined on a lookup field:
To summarize these steps, I need to expose the ID column as an additional field in the lookup:
(image copied from linked blog post above)
I'm creating my lists and lookup columns declaratively inside a Visual Studio solution, and I would like to add this additional field in the xml. How do I do this?
The xml definition for my lookup field is as follows:
<Field ID="{5D184D01-082C-4831-8757-CA2C98F05221}"
Name="EventInquiry"
DisplayName="Event Inquiry"
Type="Lookup"
Required="FALSE"
Group="Ops Inquiry Tracking Columns"
ShowField="EventCode"
List="Lists/Event Inquirys"></Field>