You can add a selection of table fields to a record.

You can select fields from an external table via ODBC. To connect to the external environment, the default connector of type Database. You can set up this default connector for the applicable project.

To find the external table name, the name that is defined in the Record table field is used.

When the field selection is added to the record, review and complete the properties of the added fields.

Standard procedure

1.	Click Connectivity studio Integration Design.
2.	Click the Documents tab.
3.	In the list, find and select the desired document of type ODBC.
4.	Click Edit.
5.	In the Record section, in the Record list, find and select the desired record.
6.	On the Fields tab, click Select fields.
7.	The next steps explain several ways in which you can select fields. You can select all fields.
	Click Select all.
8.	You can undo all field selections.
	Click Deselect all fields.
9.	You can select mandatory fields only.
	Click Select mandatory.
	Note: You can also select fields manually.
10.	Click OK.
11.	Close the page.