Relationship between datasources

[Leandro Borges]

Hello.

My report is returning the following error:
Cannot remove table Estruturas_Cargo, because it referenced in ForeignKeyConstraint Relação. Remove the constraint first.

Estruturas_Cargo it's the name of my data source.
Relação it's the name of my relationship.

From what I understand of the error is because I made a relationship from a parent data source into a child data source when the correct one would be the inverse or it could also be something else. This relationship worked until the 2015 version, now in version 2017.1.11 does not work. Can you help me solve it?

Thank you.

[HighAley]

Hello, Leandro.

Could you send us a sample that will help us to reproduce the issue?

Thank you.

[Leandro Borges]

Hello.

I'm not achieving set an example.
Could you explain to me what this error means to see if I can find out where the error is?

Thank you.

[Alex K.]

Hello,

We couldn't reproduce this error.
Could you explain your issue in more details?

Also, send us a sample that will help us to reproduce the issue.

Thank you.

[Leandro Borges]

Hello.

I can not set an example. I even tried to mount one from my query in the database exporting to excel but the error does not occur.
I tried sending a video of the problem. What extension does the forum accept?
Is there somewhere in the code not deleting an Relation wrongly?

Thank you.

[Edward]

Hi Leandro,

Please feel free to send the video to support[at]stimulsoft.com if you would zip it and split into parts that are less than 7Mb each, then we would receive it.
Alternatively, please upload the video to any cloud service.

Usually, the relation can be deleted in the designer as it was shown in here: viewtopic.php?&t=5686

Also, there is a workaround that might be of some interest to you as well: viewtopic.php?f=12&t=40436&p=80493

Thank you,
Edward

[Leandro Borges]

Hello Edward.

Did not work. Was there any other solution?

Thank you.

[Alex K.]

Hello,

We couldn't reproduce this error.

To provide another solution we need to reproduce the issue and analyze it.

Thank you.