Is it safe to edit a customers account number?
I have some irregularities i would like to sort out, and would rather maintain the customers purchase history than make a new account? If i directly change the account number - will i mess anything up?
The customer table uses a hidden sql identity column to link to transactions. Anything displayed by RMS (including the account number) can be changed without affecting the relationship to other tables.
The recommendation to back up you data and go slow is still valid. I think I know what I'm talking about but you shouldn't blindly trust anybody.
I've changed account numbers frequently and never encountered any problems. Craig
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.