Automatic field generation of combined data when new record made

[MrBeardo]

I am wondering if it is possible to automatically generate a field entry containing two fields next to each other



IE: Table2.Field1= Table1.Field1 & Table1.Field2 & Table1.Field3
or Table2.Field1 = Table2.Field1 & Field2 etc


The idea is that I want to generate a username combining the user's first & second name with their ID number ("JoeBloggs1" or "Jim.Wright_54" etc)

The ID number should be relational to another table with the same ID and match the ID of the other table.

Also I have found that the ID field which is supposed to reflect the ID number (auto-increment) of the original source table

IE: the Table2.ID field should match Table1.ID field (auto-incremented) and have the same first name and last name.

I hope this is enough to help with!

Thanks!

[June7]

This would require code to save the value to table and might not even be necessary as the value can be generated at anytime by calculation.