• Sign In
  1. Messages

Connecting multiple table with Lookup

LabKey Support Forum (Inactive)

View Message

view list print
Connecting multiple table with Lookup feifei bao  2015-05-01 11:46
Status: Closed
 
Hi,

Labkey can join views is a "lookup column". I wander can I connect multiple tables with one common column? In "Edit Design" one column can only set one lookup and also I can not edit SQL source for the tables. So I am not sure whether I can realize this with some other ways.

Best regards,

Feifei
 
 
jeckels responded:  2015-05-03 17:47
Hi Feifei,

A single column can only be configured with a single lookup, as you've discovered. You can set custom query metadata to clone the column (via the Alias Column button, not shown in the screenshot in the docs), which can be configured with a different lookup. The lookup target could be a custom query which would allow you to specify the SQL.

https://www.labkey.org/wiki/home/Documentation/page.view?name=metadataSql

Thanks,
Josh