D365 Finance & Operations and Dynamics AX Forum

Kingswaysoft N:N Relationships

  • 1.  Kingswaysoft N:N Relationships

    Posted 26 days ago
    Edited by Christine Oakes 26 days ago

    I'm not sure if this is right forum for this, but it was one of the few I had access to....

    I'm trying to establish a N:N relationship via Kingswaysoft between two custom entities.

    I'm getting all my info from SQL server in a step of OLE DB datasource. That SQL dataset contains info for the alternate key for one entity and the GUIDs of the other entity (but I have more info).

    According to Kingswaysoft's documentation, I should perform a "Create" on the Dynamics Destination step. If I do that, I get errors that I can't insert a duplicate key. Ok then, so I changed my SQL to look for the name of the other entity. If I do that, then I get 1080 records rather than a relationship being established.

    I have tried Update and I also tried Upsert. Both with varying results. Update has gotten the closest and when I perform an Advanced Find to find records that are associated with the other entity, it brings them back. However, the associated view doesn't show anything.

    I'm really stuck with this. Has anyone had any experience with the N:N using Kingwaysoft?

    Thank you!
    Christine Oakes
    Law School Admission Council
    Newtown PA
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready

If you've found this thread useful, dive deeper into User Group community content by role