I have two protocols, each with its own table. The table of protocol A has a column with foreign keys to the table of protocol B. I want to create a view table with all rows of the A-table and with additional columns from the B-table.

I’m been following this guide but I can’t really figure out how to solve this scenario. It seems like a I need a combinations of the guide’s two different scenarios because it’s two different protocols.

I’ve tried created a Direct view table, basically mirroring the table from protocol B and the creating a normal view table, viewing the table from A and adding a foreign key to the direct view table. However the added column is empty.

Table A-1

<ArrayOptions index=”0″ options=”;naming=/503″>
<ColumnOption idx=”0″ pid=”501″ type=”retrieved” options=”” />
<ColumnOption idx=”1″ pid=”502″ type=”retrieved” options=”” />
<ColumnOption idx=”2″ pid=”503″ type=”retrieved” options=”” />
<ColumnOption idx=”3″ pid=”504″ type=”retrieved” options=”” />
<ColumnOption idx=”4″ pid=”505″ type=”retrieved” options=”” />
<ColumnOption idx=”5″ pid=”506″ type=”retrieved” options=”” />
<ColumnOption idx=”6″ pid=”507″ type=”retrieved” options=”” />
<ColumnOption idx=”7″ pid=”508″ type=”retrieved” options=”” />
<ColumnOption idx=”8″ pid=”509″ type=”retrieved” options=”” />
<ColumnOption idx=”9″ pid=”510″ type=”retrieved” options=”;foreignKey=9000″ />
</ArrayOptions>

Table A-2 (Direct view of Table B)

<ArrayOptions index=”0″ options=”;volatile;view=900,remoteId;directView=702″>
<ColumnOption idx=”0″ pid=”9001″ type=”custom” value=”” options=”;view=901″ />
<ColumnOption idx=”1″ pid=”9002″ type=”custom” value=”” options=”;view=902″ />
<ColumnOption idx=”2″ pid=”9003″ type=”custom” value=”” options=”;view=903″ />
</ArrayOptions>

Table A-3 (View table of A-1 + A-2), here the last column is just populated with “Not initialized”

<ArrayOptions index=”0″ options=”;volatile;view=500″>
<ColumnOption idx=”0″ pid=”1301″ type=”custom” value=”” options=”;view=501″ />
<ColumnOption idx=”1″ pid=”1302″ type=”custom” value=”” options=”;view=502″ />
<ColumnOption idx=”2″ pid=”1303″ type=”custom” value=”” options=”;view=503″ />
<ColumnOption idx=”3″ pid=”1310″ type=”custom” value=”” options=”;view=510:9002″ />
</ArrayOptions>