Post Closed
60
Views
4
Comments
Adding rows under the same entity attribute ID

I am trying to update a database using a one to many relationship. The example I am working on "One Project" to many "Employees"

I have created a custom entity attribute ID "Project Name" of type text.


This is the updated database I am looking for. I am trying to add additional personnel just by increasing the rows under Project_Personnel

2021-03-05 13-56-11
Ricardo Pereira
 
MVP

Hi,

I believe that this post is similar to this one: https://www.outsystems.com/forums/discussion/75637/add-rows-under-the-same-attribute-entity-id/

Is duplicated, I guess.

Best regards,

Ricardo Pereira

2020-07-29 19-08-40
Sanjay Kumar Sahu

Hello Chan,


I think you want to make One-To-Many relationship between your entities 'DataBaseOne' and 'Employee', where databaseOne will have projectName which you want to map to many employees? In this case, you need to create ForeignKey attribute in Employee entity not in DataBaseOne. You should place 'Project_personal' attribute in Employee entity and select DataType as 'DatabaseOne Identifier'. You will get your desired result.


Regards,

Sanjay

2025-04-17 05-42-16
Ajit Kurane

Hello Isaiah Chan,

You can achieve  your possible outcome with below entity diagram also,

and here you can learn basic things about entity relationship

Please go through below document.

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


Hope it helps you.

Regards,

Ajit Kurane.