Lookup for multiple tables

1

Hello,

I´ve a notes table that I want to connect to a company and maybe at the same time to a person but “Company” and “Person” are different tables.

How can you do this so when you access to the company you can see the notes of the company and when you access the person you can see the notes of the person?

Thanks a lot!

2

Hi @Nacho - does having two columns one with a Lookup to Person and open with a lookup to Company work?

3

Something like this -

4

Hello @mallika,

Not the best solution for our case, will it be possible to have just one column and search for both tables?

Thanks a lot.

5

Try using a Select List type column with a Formula like this:

ListCombine(Lookup(Table1, col, col), Lookup(Table2, col, col))
2 Likes
6

Great solution!

Note, even just using a Select list type column and populating the fields with a formula or a button works just as well, you can get references (aka links) to rows in multiple other tables.