Let’s say I have two tables: Customers Products In products table I have a lookup field to customers for selecting which customers bought that product. Now, in customers table I want to see which products they have bought. How can I do that?

Reverse Lookup to Table

cnr February 12, 2019, 10:01pm 7

Of course, you can do the one way table, which works just fine:

This is done like so:

1 Like

Many to many lookups and keeping it all in sync question

Topic		Replies	Views
Lookup from multiple tables	13	3118	May 13, 2019
Many to many lookups and keeping it all in sync question	13	2243	April 6, 2020
Action formulas Showcase	4	567	February 22, 2022
Calling information from multiple tables in a table	3	1541	February 19, 2021
How do you copy over 'select list' options from one table to another?	5	952	January 7, 2021