This discussion is archived
2 Replies Latest reply: Feb 18, 2013 4:19 AM by FabriceC RSS

Identifying relation and sequence within parent

FabriceC Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points