4.16 Importing lookup lists

Importing Lookup lists

Use this function to import an existing table as a lookup list. You can import lookup list tables data from any already existing Field-Map project or  external tables.

The table must be in FireBird (.fdb), MS Excel (.xls or .xlsx) or MS Access (.accdb) format. It is necessary that the table contains a field with an identification (either numeric ID or alphanumeric ID as a matching type of a lookup list) and a description field for each item (this field appears in Field-Map Data Collector lookup list menu). In the case of a conditional lookup lists, the table must contain also a field with a master ID.

1. Add a new Lookup list type attribute.

2. In the Select Lookup List dialog box click the Import lookup list button.

3. Select the path to the source project which the lookup list will be imported from
4. and then click the database file of the project (or a source file with the lookup list data to import).

5. A new window Open Table appears, select the lookup list to import.
6. Click OK.

7. A Table preview appears.

8. Select the field which will represent the lookup list ID fields.
9. Select the field which will represent the lookup list Value fields.
10. Click OK.

11. Rename the lookup list.
12. Click OK.

13. The lookup list has been imported.