I have a table in my database for my customers. Sometime my customers change thier address but I want to keep these changes in other table. How it is possible. Can someone help me. Thx
I have a table in my database for my customers. Sometime my customers change thier address but I want to keep these changes in other table. How it is possible. Can someone help me. Thx
Customer address will have to be a separate table so that you can have multiple addresses per customer. You will then have a date or an active flag or something to denote this is the active one. A date start or date end is probably the best method.