Best Practice default in table or use update query

[newtoAccess]

What is the most correct way to do the following.
I have the user enter first and last name in seperate fields on a form that fills the table. Normal stuff.
here are the fields I want to fill automaticly.
[Full_Name] = full name --[F_Int], = first Initial --[L_Int], = Last initial --[F_Int_L_name] = first Initial and Last Name -- [F_Name_L_Int] = first Name and Last Initial

1- Should I have or can I have the table set the field default of above fields to Left([F_Name],1) to set the first Initial field, Left([L_Name],1) to set the last Initial field, etc OR

2- or should I Create an update query to Left([F_Name],1), Left([F_Name],1) etc

[pbaldy]

In my opinion, the correct thing to do is option 3; don't store those fields at all. They can all be derived from first and last names, so I wouldn't store them. Calculate them as and when needed.

[newtoAccess]

OK Thanks
Willgive it a try