Warning Triangle massive or batch fix. How to do it?

[OmarRosado]

Hello dear colleagues,

While trying to improve some behavior of the app, I added a second Key field to the table PROCESO, then i rolled back the change.

Now I have this warning triangle on every row of the main table CASOS. Even though the shown value is the right value, How can I fix this in a massive or batch way, instead of having to edit every 300 rows and to select from the dropdown and save the PROCESO field?

Thank you all in advance.

[Aurelien · Accepted solution]

Hi @OmarRosado

Warning triangle is indicating your value does not refer to the key_column of the table it refers to.

More information here:

What does an exclamation mark in a yellow tri... Questions

@Zachary_Gatch1 Adding to what @Aleksi_Alkio has said, this occurs when you have broken references. A broken reference occurs when the reference key does not match any of the existing keys in the referenced table. There can be several possible causes: the referenced row might have been deleted, the key might have been modified, etc. To fix this, please make sure that the broken reference has a matching key in the referenced table.

Regarding the context you provided, I think the key_column in the Ref table has moved. You may want to check that.

[OmarRosado]

At the beginning the main table CASOS has a field (PROCESO) reference to a second table PROCESOS. I tried to make something new, just to make my app better.
What was new? I added a new column to the second table PROCESOS and make it the key. And set the field in the main table to target this new reference. I was aware that the first referenced would be broken.

Then I regret and erase the new key field and set the main table back to the original reference. As you can see the original column wasn’t deleted never.

Now the main table CASOS, in the detail view shows the right original value (PROCESO field) but with the yellow triangle next to it.

The right values are there in the worksheet. The reference is well settled as in the beginning. But the triangle still on every time I view the detail. The only way to get rid of that is to edit, select the value on the PROCESOS dropdown list abd then save the CASO row.

Any advice to fix it in a batch way?

[OmarRosado]

Thank you all. It was my fault. Following your indications I found that I was wrong and mistaking different tables. My bad. Thank you all.

[OmarRosado]

Thank you, I confused two tables. It works fine after like you adviced.