Table Reference Editor dialog box

This is a feature of JBuilder Enterprise.

Use the Table Reference Editor to reference another table and map columns in that table to fields in this entity bean. Table references are available for entity beans that target the Borland Enterprise Server only.

To display the Table Reference Editor,

  1. Display the inspector for an entity bean in the EJB Designer.
  2. Click the Add button.

You also use the Table Reference Editor to define a relationship between two tables.

To display the Table Reference Editor when you are defining a relationship,

  1. Link two entity beans in the EJB Designer to specify the relationship.
  2. Click the new field added to an entity bean to display the relationship inspector.
  3. Click the Edit Table Reference button.

Table (on left)

Displays the name of the table for the current entity bean and lists the columns in the table.

Table (on right)

Use the drop-down list to select the table you want the entity bean to reference.

Click and drag to draw links between the columns on the left and the columns on the right. These links represent the foreign key relationships between the tables.

Add Cross Table button

Use the Cross Table button to add a third table in the middle of the editor. Use a cross table when it has at least one column in common with each of the other two tables but the other two tables have no columns in common with each other.

Remove Cross Table button

Removes the cross table.

Clear

Removes any linking lines between tables.

See also