Toad World® Forums

How to create a one-to-one relationship?


I have two tables that have a one-to-one relationship linked by a common attribute. How do I represent that in TDM?




You need to edit the relationship and define the settings in the Cardinality area.

To create a relationship and to edit it:

  1. Click the relationship icon on the toolbar.
  2. Click parent entity and then child entity in WS.
  3. Double-click the relationship to edit it.
  4. In the Relationship Properties dialog | General tab | see the Cardinality area.

If you have more questions, please write me back.