Preserving Zeros

[jasongodoy]

Hello everyone,

My issue seems pretty simple. The issue is, I set a variable to pick up a "PK" unique auto-entered number. This number is 7 digits long. The number format is 0000001, 0000002 etc. In a script I set a variable "my_num" to that "PK" so "my_num" should equal 0000001. Then I set a field in another table to that variable and the number that shows up is 1, 2 etc. The zeros are discarded. Is there any way to preserve these zeros??

Thanks in advance,

J

[Lee Smith]

change the field to Text Format.

Lee

[jasongodoy]

Thanks so much Lee! Worked like a charm.

J