Get rid of deleted rows in relation columns

1

Hello!

If I delete a row, its “ghost” still appears in any relation column that it was in:

image
image595×185 5.21 KB

Is there a way to prevent this from happening or remove them completely?

1 Like
2

You can remove them by clearing the value on the relation column for each of the affected rows.

You can get all rows with “ghost” values by filtering your affected table with: Source_Relation_Table.Contains(thisRow.Relation)

Then you can set them all to blank or to a different value using ModifyRows.

1 Like