Text Column Holds value of ID

[ShaimaaT]

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!

 

[philhege]

on clicking the button that opens this lookup table

What button? In an application? In Management Studio?

Looks like the problem is in the application logic.

-----------
With business clients like mine, you'd be better off herding cats.