Hi Mariap,

You have a relation N:M, so, you new create a new entity. Right? The new table, will have dynamic data? Can relations be changed?

https://success.outsystems.com/Documentation/10/Developing_an_Application/Use_Data/Data_Modeling/Entity_Relationships

Hi Mariap,

What error are you get when try to do it?  I test it here and it works well.

Regards

Fabio Fantato

I have 2 static entities (imagine A and B) and I created a 3rd to have static association (imagine C), with foreign key AId and BId, with an unique index to make sure that no duplicate records exist. 

Message is "Generic SQL Error. Cannot insert duplicate key row in object 'dbo.OSUSR_...' with unique index ... The duplicate key value is (0,0)".

However, none of the records is (Null, Null).

Thanks

Hi,

I don't have any problem:

Check attributes and indexes in your 3rd table.

I had the same error, but my solution was delete the unique index.

The thought the steps to insert a new static record that has others static entities as a field, are:

 1 - Insert every rows with 0 or null;

 2 - Consult the others stitaci entities to get the correct ID filtering by Label selected in service studio;

 3 - Update the new records from 0 or null TO the correct values.

It's work for me. I had the same erro tha you got guys and analyzing the deploy errors logs I arrived in this solution.

I hope you get this solution too.


"It's a big mistake create row with your own hands, and so create it duplicated" :D