Lookups/Links to primary key/normal values in SQL queries

LabKey Support Forum (Inactive)
Lookups/Links to primary key/normal values in SQL queries max diesner  2020-12-12 00:17
Status: Active
 

Hi Chet,

thanks for the answer. I finally had last week time to review everything again and with your walk through i have found my mistake - I had a space in the primary key column name - rookie mistake as i have found out. Sry for the inconvinience. Nevertheless, everything is working as it should, i also understand and can setup the XML metadata as i want which solved quiet some problems ;). So thanks again!

I have a follow up question; is there an easy way to setup dependent lookups, e.g.:

Lookup 1
Machine 1
Machine 2

Dependent Lookup 2
(Machine 1)
Column 1
Column 2

or depending on the selection in lookup 1
(Machine 2)
Column 1
Column 2
Column 3

Another example directly from the server would be when adding a single list module on a labkey page. There you can select a list and then a second dropdown menue can be selected in order to select from the list of the corresponding list views.

Is there a native way through the XML data to set this up or has this to be implemented via for example Javascript?

Thanks again for your awesome work!

Max