Hi Chet,

i just had time to revisit this problem on our server.

so here is some example code where it is also not working. I have a list with orders. The primary key is Ordernumber Labkey, the query should gives back just the entries with the status on unprocessed (to implement it in a dropdown menue elsewhere:

SELECT Orders."Ordernumber Labkey",
FROM Orders
WHERE Orders."Processed?"=true

This gives back the correct list with entries but the look up is not linked to the original list as explained earlier.

I also edited the Metadata XML file as follows:

<tables xmlns="http://labkey.org/data/xml"> <table tableName="Orders-unprocessed" tableDbType="NOT_IN_DB"> <columns> <column columnName="Ordernumber Labkey"> <fk> <fkColumnName>Ordernumber</fkColumnName> <fkTable>Orders</fkTable> <fkDbSchema>lists</fkDbSchema> </fk> </column> </columns> </table> </tables> ***

Which is not altering anything. I am probably missing something but am not sure what.

looking forward to your help!

Max