Customer phone number column in 'address' table to be added into 'customer' table

[hasimj]

Hello,

 

I have a question regards table update.

 

I want customer phone number column in 'address' table to be added into 'customer' table and updated same time when address table updates. Data should be inserted to both columns at the same time. Is it possible? or any solution to accomplished the task.

 

Appreciate if someone could kindly look into this

 

Thanks. 

[vekia]

customers can have many addresses

what phone number to display then?