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
Lookup for multiple tables	5	1393	March 22, 2021
Return data from fields in same row after lookup	2	1457	March 7, 2019
Lookup from multiple tables	13	3118	May 13, 2019
Multidimensional Database Question (Foreign Key)	3	670	February 9, 2019
Calling information from multiple tables in a table	3	1535	February 19, 2021

Combining 2 different Columns from 2 different tables in a Lookup

Related Topics