Drop-down and Pop-up problem
I have a 1:1 correspondence between Asset and User. Asset has user_id column.
What I would like: when I look at Assets I would like to display full name of the user, and have ability to change user this asset belogns to (via dropdown or popup), but not allowing any changes to the Users info.
What I tried: created value list called 'Users' which are based by user id and show Full Name in second field only. When i have it, when i am displaying the data i would see an id but then when i click i would see dropdown with user names. Seeing id is very inconvenient because I have to click to see who the user is.
I also tried to create a 1:1 relationship between Asset and User, and then in the Asset layout for Asset.user_id field to specify Full Name from the User table. Problem: when i click in the field i can change the value, and that changes the Full Name in the (User), which I do not want. And I suspect it acually puts id value in the Full Name as well into the user table. Even with popup I could still corrupt the user full name.
Any help is appreciated.