easy question

[meekychunky2004]

How do i auto fill a field with the first three letters of another field in the same table?

 

[dcx693]

You can use an update query. If you need to do the same for entries going forward, then you need to do something in your forms.

Why do you want to store part of one field within another?

 

[meekychunky2004]

You can use an update query. If you need to do the same for entries going forward, then you need to do something in your forms.

Why do you want to store part of one field within another?

To create an ID rather than try to auto-generate one. I have now managed to do this.