I apologize for the vagueness 🙂

What I have is table1 which has been imported externally with 4 fields including an (AccountDescription) field

srvnameAccountAccountDescriptionDATE_CREATION

-----------------------------------------------------------------------------

I need to be able to copy only 3 fields from another similar table whenever a new record is added as less the (AccountDescription) ,the data in this field is manually entered by me

srvnameAccount DATE_CREATION

I hope it's clearer