Skip to Content

Need to create many to many relationship in Power Designer

Hi ,

I am drawing the logical model that contains many to many relationship between few tables.

I have checked the logical model relationships and found only one to one, one to many and many to to one relationships . There is no many to many relationship.

I need to draw many to many relationship.

Please find the below screenshot for reference.

How can i achieve this in the logical model..

Thanks & Regards,

Venkata Ramana Paidi

pastedImage_0.png (31.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Nov 09, 2015 at 07:17 AM

    Hi,

    Many-to-many relationships are disabled by default in the LDM. To enable them, select Tools > Model Options and check the "Allow n-n relationships" checkbox on the "Model Settings" page.

    For more info, see Setting CDM/LDM Model Options.

    Add a comment
    10|10000 characters needed characters exceeded

    • A couple of related points for you, in case you're not aware of them:

      • You can get PD to convert the many-to-many relationship (in fact, any relationship) to an entity - just right-click the relationship in a diagram or the Browser, and select 'Change to Entity'.
      • If you generate a CDM or LDM from this model, and you don't want many-to-many relationships to be converted into an entity, you'll need to make sure the target model allows many-to-many relationships - click on 'Configure Model Options' on the Details tab of the model generation wizard.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.