0 Replies Latest reply on Sep 21, 2004 10:18 AM by thl-net

    Relation field part of primary key

    thl-net Newbie

      Hi,
      I have a Typical Master Detail relation:

      Customer
      customerId integer not null (PK)
      name ...

      Bill
      fk_customerId integer not null (PK)
      billNumber integer not null (PK)
      ...

      For my CMP Entities, I'd like to use a 1:n Relation between the two entities.
      The billNumber is unique within one customer. How do I declare the relation, that billNumber and fk_customerId is the primary key of the bill entity. And at the same time fk_customerId is the cmr-field.