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…

Hi Everyone any good tricks out there that can be used to do the above ? Thank you so much

How do you make doc public without requiring guest to ask for permission to accesss the doc ? I only know how to give access only when i know the person’s email address Apologies @Steve_Yang

@M_Hermi Embed [image] [image] [image]

Thanks Paul for your help ! Appreciate all your contribution in this community

Combining 2 different Columns from 2 different tables in a Lookup

Steve_Yang May 4, 2020, 9:40am 5

@M_Hermi Embed

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	1521	March 22, 2021
Select lists as table with multiple columns	7	2974	January 16, 2021
Retrieve all selectable items from a list column	3	1562	December 29, 2018
Lookup from Table vs Selectable List	12	4024	March 20, 2019
Reference individual cell data in another table	2	3113	August 6, 2019

Combining 2 different Columns from 2 different tables in a Lookup

Related topics