2 Replies Latest reply: Feb 18, 2013 12:19 PM by FabriceC RSS

    Identifying relation and sequence within parent

    FabriceC
      Hi everybody,

      does someone know if there is something like the Oracle Designer "Seq in Parent" auto-gen type ?
      It was very useful to generate valuse from 1 to n for each row of same parent.

      Ex :

      Order (ID => PK)
      1
      2
      3

      OrderItem (OrderID => PFK - OrderItemID => PK)
      1 - 1
      1 - 2
      1 - 3
      2 - 1
      2 - 2
      3 - 1
      ....


      thanks

      regards

      Fabrice