Release 10.1A: OpenEdge Development:
Progress Dynamics Getting Started

> ## Setting the SDO foreign fields

> Now that your new page has its SDOs, you must define the relationship between the Order SDO and the external Customer SDO from which the Order SDO gets its key value. Remember that you want to display Orders for the currently selected Customer. You must identify the key value that gets passed from the Customer SDO in the Customer Browse Window to this Order SDO. This list of key values is called the Foreign Fields list. As with most common AppBuilder tasks, you can use several methods to set up these relationships.

> In the tutorial application, the Order SDO’s query is filtered by the `customer_obj` field, and the parent Customer SDO’s `customer_obj` field is passed in and inserted into the Order SDO’s query.

> | To set the foreign fields:

> 1. Select the artorfullo SDO in the folder’s grid.

> 2. Choose the Dynamic Properties button from the instance toolbar inside the folder page.

> 3. Type art_order.customer_obj,customer_obj for the value of the ForeignFields attribute, as shown:

> 4. Select the artolfullo SDO in the folder’s grid.

> 5. Choose the Foreign-Field Mapping button beside the Foreign fields editor. The Foreign-Field Mapping dialog box appears:

> 6. Select order_obj in the Source column and art_orderline.order_obj in the Target column.

> 7. Choose the Map button, and exit the Foreign-Field Mapping dialog box.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095