Creating a Look-up Table
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:
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