Populate relationship property on existing data
Hello,
I am wondering if anyone can help me with an issue we are facing. We are trying to add a parent-child relationship between 2 tables in the database that already contain data. We are able to add the new relationship property to the required data classes, and set the desired cardinality. We have also included code that will add the relationship using the Insert() method to new data that comes in.
The problem we have is how do we add the relationship to data that already exists in the database?
After the relationship properties were deployed, the data in the children table is no longer visible in the db table. We know the data is still there, because it is still in the Data Global, and if we remove the relationship properties we can once again see it in the db table. We tried to use a %NOINDEX clause in a Select statement, to see if it would display the data, but that didn't help.
Once we are able to display the records that have null relationships, we are planning to employ the logic we have in place for new data: open object of parent, set the relationship between the two, save. However, without being able to view the existing data, we are stuck how to proceed.
Would love any help that could be provided.
Thank you!
Craig Bishop