How can i pass data from primary table to another table?

[kekewong]

ok , i have a primary table that have a field of "job", then i create another table that have a field of "job" too , then how can i do this task?

Whatever i type a data into the primary table("Job" field) i want it to duplicate the data into the another table("Job" field) . is it possible to do this? can anyone guild me to do ?

 

[neileg]

Doesn't sound like a good design. Why do you want to do this?

Updating two tables is usually best done with a form/subform.