HELP with access

[LaFlame]

Im having problems with my tables in access...im trying to combine 2 tables together...not entirely...one field of table2 will update a field in table1...it will fill in the blanks....


heres a screen shot


the relationship is one to one...(imageid and bateid)....
can anyone help me out?? thanks

[bigit]

One :

Copy and paste. but i think you have tried it

Second :

Input one row right of where you want ot update. and use the mathematic function. If this not work, go to next step

Third:

Google it