I have an app with profiles and user names and ratings for users. When a user edits their name all previous ratings drop off. I understand it is due to the relation between the user name and the rating. Does anyone know of a way to maintain this info even if the user name changes?
Using name to establish a relation is bad practices for exactly that reason. Names can change. It’s better to use Row ID’s to create relations because Row ID’s will not change. You would use the Row ID from your user table and write that to each new row in the ratings table. Then use the ID’s to create the relation.