Hello Codans, I want to have the option of selecting from 2 different lists depending on a criteria. In the table [Complete List] I’d like to be able to have 2 lists available from which I could select some data. For example, if Country = BFA, HTI or SEN, in column ‘Activity’ from table ‘Complete …

Is it possible to do a lookup to two different tables based on a criteria?

Daniel_Stieber May 20, 2022, 8:15pm 2

There is a recent thread with (as I understand) a quite similar request with two solutions. Maybe this gives you a hint in the right direction?

Topic		Replies	Views
Dependent Select List	7	1486	May 9, 2022
Can you do a conditional selection from one table to another?	11	4479	September 10, 2018
Combine data from two tables based on selection in third	3	411	January 3, 2023
Dynamic select list items based on a lookup column	4	4026	January 17, 2020
Pull Data from Two Tables in a Single View/Table?	8	2259	October 1, 2018