hard table with lookup to second hard table in different folder

LabKey Support Forum (Inactive)
hard table with lookup to second hard table in different folder Will Holtz  2015-09-09 15:21
Status: Closed
 
Hi Jon,

Initially I had metadata for the lookup column with just:
       <column columnName="product"></column>
and later I tried:
      <column columnName="product">
        <fk>
          <fkFolderPath>/home/folder1</fkFolderPath>
          <fkTable>Table1</fkTable>
          <fkDbSchema>Schema1</fkDbSchema>
        </fk>
      </column>
Neither of these resulted in a functional lookup within labkey.

If I edit the metadata from within the labkey schema browser, it appears to already have the lookup configured, as the 'Type' column shows the fk schema and table. However, if I try to edit the lookup, the 'Choose Field' dialog has the value for schema, but doesn't have values for Folder or Table (they say 'Folder' and 'no tables found'). If I then set Folder to /home/Module1, I can then select the table. If I save this and go back to the schema browser, the lookup column is still empty for this field, and when I view the data, I see the integer values for this column.

thanks for you help!
-Will