Text column holds value of ID

[Shaimaa T]

Hi all,


I have a table Actions as follow


Action ID Action
1 cutting
2 sowing
3 ripping
.. ..


At some time , on clicking the button that opens this lookup table I found some of the values of Action equal to Action ID


Action ID Action
1 1
2 sowing
3 3


What are all possible scenarios that would lead to Action column taking value of Action ID?


Many thanks!

[Bob Phillips]

Sounds like a code error that updates the table.

[Shaimaa T]

But I can't find anywhere in code an update statement that sets Action to be Action ID!