You’re offline. This is a read only version of the page.
150
I have created the two dataverse table: Data and Type.
In Type Table we have type A,B,C,D,E.
I have given type table as one to many relationship to masterdata.
But when I am trying to add multiple value in types. Its not working.
It is giving "This record cannot be added because it already has a parent record." this notification in model driven.
Could anyone please help !!
Thanks in advance
Feels like you may be trying to use "Add Existing" on a subgrid and selecting a record that already has its lookup field populated. If it is a 'Type' table that probably means you either have the relationship the wrong way around or you really want a many-to-many
When relating rows from different tables using their one-to-many relationship, a child record cannot be linked to more than one parent records. This usually gives the error you are writing here.
For example, if type is a child record of data, then type A cannot belong to data 1 and 2, it must be related to only one of them. If you need type a to be related to more than one row in the Data table, then you will need to create a one to many relationship from type to data. If you already have a one-to-many relationship from data to type then you theoretically have a many to many relationship, however it cannot be handled using one relationship alone so you will need to use either the 1:n or the n:1 relationship depending on which data-operation you are performing. This is not recommended.
I would reconsider if the data-model could be built differently.
If you explain the use-case then we might be able to help with an alternative.
@Moira0509 Your question is unclear. Please provide additional context, screenshots, logs and data model design
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
