Managing Lookup Columns
Lookup columns can be created when there is a many-to-one relation between tables. These columns can be added to the Details table to represent specific data from a related Master table. For example, the "Projects" table may need to contain the Client Company, Client Phone, and Client Email from the related "Clients" table.
Using one relation, you can add as many lookup columns as you need.
Furthermore, when a reference column of Many-To-One cardinality is created, and a
Proxy column is chosen in the reference column settings, the lookup column displaying Proxy column values is automatically added to a table.
To add a lookup column to a related table:
Setuplink in the top right corner of the window.
Select the table you need.
From the setup menu, select
Relationsform, click on the
Add Lookupbutton next to the necessary relation:
The Lookup column form will be displayed:
Fill in the displayed form to create a Lookup column.