Define Merge Actions for Relationship Database Properties

Use the Database page in the Relationship Properties window to define whether or not to overwrite the relationship's database properties.

The Relationship Properties window is available in the Relationship Editor (accessed from within the Object Manager in the mApp Editor).

Good to know:

  • You can only configure separate merge actions for individual relationships and relationship properties if the Business Object is set to Merge in the Business Object Properties window (mApps page). If the Business Object is set to any other option, or if Include in mApp is cleared, then you cannot configure separate merge actions for individual relationship properties.
  • Database properties allow you to create and enable foreign keys for the relationship. Foreign Keys establish and enforce a link between tables in a relational database, and are required by SQL Reporting Services. It is recommended that you do not use foreign keys unless you have a specific need to do so.
  • For more information about defining relationship database properties, refer to Define Database Properties for a Relationship.
  • If you are configuring merge actions for Business Object relationships that were previously applied as part of a Protected mApp™ Solution, the main differences are:

    • You see a shield icon next to each content-protected relationship.
    • If a Business Object relationship is content-protected, it cannot be deleted.
    • Relationships created during the installation of a Protected mApp Solution cannot be edited or deleted.
    • If you create a new relationship, you can edit and delete it.
    • See Protected mApp™ Solutions.

To define merge actions for relationship database properties:

  1. Add a Business Object to a mApp using the Add Business Object to mApp wizard.
  2. Open the Relationship Properties window:
    1. In the Object Manager within the mApp Editor, select the Edit Relationships task in the Structure area.

      The Relationship Editor opens.

      You can also select Edit Relationship Relationship Icon on the mApp Editor Toolbar to open the Relationship Editor.

    2. Select a relationship, and then select Edit.
  3. Set the relationship to Merge:
    1. Select the mApps page, and then select Include in mApp.
    2. In the Options area, select Import to Target System.
    3. From the If already present drop-down list, select Merge as the merge action for the relationship.
  4. Select the Database page.
  5. Select mApp [variable here] Merge Actions, and then select a merge action:
    • Do not overwrite database options: Select this option to leave the relationship's database properties unchanged in the target system when the mApp Solution is applied.
    • Overwrite database options: Select this option to overwrite the relationship's database properties in the target system when the mApp Solution is applied.
  6. Select OK.

  7. Prepare the mApp Solution for Distribution (File > Prepare mApp for Distribution), or save the mApp Solution (File > Save mApp to Disk) to continue making other changes.