Autotext

I was wondering if anyone had any information they could point me to that will show me how to automatically assign a value to a certain field.

I already have a primary key. I added a new field and I was wondering how I could go about adding a specific value multiple times. For instance.

Charge_Line Freight_ID
1 Fr01
2 Fr02

So I would like to assign Fr01 to charge line one and Fr02 to charge line 2. I could do this manually but I have a huge amount of entries, furthermore I plan on doing this to future records.

Is this possible to do this in SQL statement?

Any help would be great. Thank you!