Tree View
Tree
List View
Alphabetical List
Share
Share
Search:
id:
107

name:

Creating a Look-up Table



description:
A look-up table lets you select data from a drop-down list in any one of your tables. Like this:


To let the system know which table you want to pick from, you have to create a look-up table.

Adding a look-up table with Import Data


If you are adding a look-up table with a lot of records, Import data is the fastest way to create it.

Go to Develop > Import Data.


Enter a Table Name.



Check the checkbox beside "First row contains field names".

In the box below, enter:

Clients
XYZ Company
ABC Inc
JKL Manufacturing
etc....

Then click "Import Data!". Leave the advanced features
unchecked for look-up tables.




See also Convert a Field to a Drop-Down and Adding a Drop-Down Field


ParentTopic: