database problem,inter conected table

[Sharma Neha]

I have one A table in a database which contains some columns like for eg- key,name ,age,add,phone no.
Another table B in a database contains name,status.
I hav a form in which contain key textbox,i want to to update status where name is name of person whose key i hav entered in a form.
plzz reply

[r035198x]

Do not double post. It's against site rules.