Create a Relationship Between Business Objects Based on a DB Table

Business object relationships simplify the task of creating pages with parent-child relationships or drop-down lists referencing another object’s values. When you first create a parent, then a child business object, their relationship is automatically created. For other scenarios, you create relationships either manually or by adding a referenced field.

• Follow these steps if a referenced field (based on a foreign key column that links to a table) that doesn’t yet have a business object was included when your business object was created:

  1. Create the business object for the referenced field.

  2. Manually create a relationship to the referenced business object from your source business object’s Relationships editor, just as you would when defining a relationship between native business objects.

• Follow these steps if a referenced field was not included when your business object was created:

  1. Create the business object for the referenced field.

  2. Add the referenced field from your source business object’s Fields editor.

If the referenced field is missing from the source business object (for example, if the Department object’s departmentId field referenced in the Employee object was accidentally deleted), an error will appear when you try to create the relationship, indicating that a suitable mapping field wasn’t found. To resolve this, re-add the referenced field to automatically establish the relationship.