Adding Additional Fields from the Table to FootPrints
In Step 4, the last step in the configuration process,
you can add additional fields to the Address Book that are available in
the external data source table. The
final page for configuring the additional fields is identical to the page
you use to add new fields to a FootPrints
Address Book or a FootPrints Workspace,
with the addition of the External
Database Field drop-down list.
To configure additional fields for the Address Book:
- Click on the drop-down
list of fields in External
Database Field.
- In the Name
field, enter the name that FootPrints
uses for this information. You
can use the same name used in the external data source.
- Define the Permissions
for FootPrints users.
- Click Create Field. The
field is added to the Field
List.
- Continue adding fields
until you have all the fields from the external data source that you want
to include in the Address Book.
- Select a Primary
Key from the field list to be used to find issues related to the
specified contact.
If any records in the external database are missing data
in the Primary
Key field you select, FootPrints cannot find that record. This
is a specific characteristic of Access.
- If required, select
a field to be used as the Organizational
Unit. This
is useful for reporting and searching.
When you have finished, click Finish.