Maybe I was not very clear. [u]Table User_detail[/u] id(autoInc), username, password, address1, address2, zip, country(id from country table), email, phone. [u]Table country[/u] id(auto inc), country ___________________________ User needs to update record and this need to pull the country data and then update if userchanges it. This should be a pull down menu. I can get some of it working but feel an easier way of doing it maybe out there. So the User picks update details. Form shows all fields that had been filled in before. User updates them and presses submit. Any Ideas. Getting a little lost in php/mysql today. Cannot see wood for the trees. regards E