So from a dataverse perspective let me explain
Table A
Table B
If you have data that is coming from files (like Excel), you have to import them in a way so that the GUIDs that are probably in the Excel file, is actually assigned as the ID for the Row.
So imagine this, I just want to provide some understanding
Let's say in Table B you have a LookUp To Table A, so you need to put the ID of Table A into the LookUp field of the column in Table B, so that Table B knows how to access the "Linked" record if you will.
Now lets say you create a Row in Table A
The Row is assigned a generated GUID, but for my example let's pretend it generated this value 1234567890 (pretend its a GUID)
Now in Table B
You go to create a Row, and when you do, you assign Table A's Row ID 1234567890 into the lookup column.
Now they are linked.
Now lets say you export the data for both Tables
1. You have to make sure that the GUIDs from Table A are the same as they were in the Previous Environment, and you have to make sure to import Table A first, because Table B is dependent on Table A
2. If you import Table B first it will give you an error as that Row in Table A doesn't exist
2. If you do not import Table A first AND make sure the GUID is the same as the over environment, AND Table B's exported data is pointing to 1234567890, guess what... you will get the Error because even though Table A might have that single row, when it got imported into the NEW environment it got a new guid 888332211 and now Table B is orphaned from A
So either
1) the imports have to be in the right order AND it has to be done so the GUIDS stay the same
OR
2) the import has to be done so that the import process imports Table A, stores the guids for each row, then knows how to Map the rows in B, to the NEW guids in A.
I cannot see the details of how its being told you how to do it, because my Champ account is still not accessible
So
@mmbr1606 or
@timl may be able to give you specifics beyond me telling you to make sure to import them IN order Table A first.
If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.
Thank you!
Sincerely, Michael Gernaey
