Hi,
I have customer register form (with ssn,fname,lname,address,apt,city,state,zip,custid) which will store datas in 4 different tables.
I am trying to create more controls like Add,Update,Delete.
For updating ,i am getting their custid as input and i need to update all tables by using custid.
I know that for updating we need to use this command, "Update table customer set name ="fsgf" where custid = ' &idtext.text &'"
But i need to update morethan 8-9 columns(ssn,fname...).Do i need to do this update query 9 times or is there anyother way for this?
thanks