Lookup Dropdown Widget for Dataset to Dataset FKs

LabKey Support Forum
Lookup Dropdown Widget for Dataset to Dataset FKs Matt V  2018-12-12 15:47
Status: Closed
 

Hello,
I have a handful of datasets with FKs (lookups) out to lists and other datasets. On the insert/edit forms, the list lookups render as dropdown widgets with available options included. However, the dataset-->dataset lookups continue to render as plain text input boxes.

Is this expected behavior, or is there some way to force the dropdown widget type? I've played around with query.xml, the gui, and even manually added FKs to the table with no luck.

Thanks.

 
 
Jon (LabKey DevOps) responded:  2018-12-26 14:09
Hi Matt,

Datasets typically do not have issues with lookups and dropdown boxes usually do generate.

However, what kind of datasets are you lookup to? Most datasets usually have 2-3 fields that are looked at for its primary key functionality, such as ParticipantId & Date, ParticipantId & VisitId, or the other two with a 3rd value being used. (Demographics datasets are an exception since it mainly uses the ParticipantId as its primary key.)

Do you have a sample study archive you could provide us that shows this dataset you created with all of its lookups for us to check out on our end?

Regards,

Jon