Hey Community, I would like to do a lookup from 2 different columns in 2 different tables. So that when i add a new data inside the Incoming Letter Table i can select the From Column from both Suppliers and Clients. Thanks in Advance

To answer your question — you can make a select list and write a formula for your list options that will combine items from two tables: [image] Depending on your needs, this may or may not be a good solution. Since this column now may contain items of not the same type (items from Suppliers and i…

Combining 2 different Columns from 2 different tables in a Lookup

Steve_Yang May 4, 2020, 9:40am 5

@M_Hermi Embed

1 Like

No help needed - Just a question to ask about : Concatenate() a list of sequential and/or non-sequential numbers?

Topic		Replies	Views
Column with multiple values from a different table	2	1891	October 15, 2020
Lookup for multiple tables	5	1466	March 22, 2021
Return data from fields in same row after lookup	2	1568	March 7, 2019
Lookup from multiple tables	13	3261	May 13, 2019
Pulling Data from another Table	2	2741	September 29, 2021

Combining 2 different Columns from 2 different tables in a Lookup

Related topics