Adding base or secondary tables to IDOs

When you create an IDO, you must specify a primary base table.

If there are columns in other tables that have a relationship with the primary base table, and if you want to expose these columns as properties in the IDO, you must also add the related table to the IDO as either a base table or a secondary table.

You can add tables to IDOs only if you have first checked out the IDO for which you want to create the table. Use the IDOs form to check out the IDO. Once the IDO has been checked out, you can click the New Table button on either the IDOs form or the IDO Tables form to launch the IDO Table Wizard.

  1. On the IDO Table Wizard form, provide this information:
    Table Name
    Select the table you want to add.
    Table Alias
    Provide a unique, valid SQL identifier to be used for this table. This alias is used to reference the table in join specifications and in generated SQL. This is commonly a shortened version of the table name.
    Table Type
    Select the type of table that represents the intended use of the new table:
    • Base: For additional tables that have a one-to-one relationship with the primary base table, share the same key values as the primary base table, and are updated through the collection, select this option.
    • Secondary: For tables that are added to an IDO and are not base tables, select this option. Columns on secondary tables that are exposed as properties on the IDO are read-only.
    Join Type
    Select one of these options:
    • Inner: Select this option only if the columns referenced in the join are not nullable and the join is on a foreign key.
    • Left Outer: Select this option in all other situations.
  2. If you are adding a secondary table, specify the Join Conditions, using the fields provided.
  3. Click OK.

The table and join conditions are added to the IDO.