It seems as if only Text is available to select. We require the Key to be available to build relationships and to view data
I might have two workarounds. They are both cumbersome but they do work. 1) Use APD to create a CSV version of your query. This solution is also recommended by others regarding this same issue. 2) Create an additional DSO where you replace important fields by tekst-type fields (ie 0TXTSH). Next, place a query on top of this DSO (with OLEDB flag set). This will give you the key-values instead of the text-value. Like I said, its cumbersome but it works.
