i have two tables
1. location
2. hardware

in the location tables
there is one field called USER the data type for user is text...

in the same way in the hardware i need to add to add another field called user..this field gets updates and copy old user details from location..i'm using microsoft acccess 2010...

please anyone help me