Gossamer Forum
Home : Products : DBMan SQL : Discussion :

"Owner" select field can only be changed to self

Quote Reply
"Owner" select field can only be changed to self
Hi I have a select field titled "Owner". When a user adds a record to the database the owner select field is automatically set to the userid of the record creator ( I have all of the userid's of users in the select field). Now if the user wants to change the owner field to someone else I want a error message to come up..something like..."you cannot transfer ownership to another user. A user can only transfer ownership to their self."

And if the the person modifying the record is setting the owner field to their self then everything should go through fine. Any ideas how I could do this?

Any ideas will be appreciated Cool
Reena
Subject Author Views Date
Thread "Owner" select field can only be changed to self Reena0330 3169 Aug 8, 2002, 3:28 PM
Thread Re: [Reena0330] "Owner" select field can only be changed to self
jean 3059 Aug 12, 2002, 11:57 AM
Post Re: [jean] "Owner" select field can only be changed to self
Reena0330 3060 Aug 12, 2002, 1:29 PM
Post Re: [jean] "Owner" select field can only be changed to self
Reena0330 3045 Aug 13, 2002, 1:10 PM
Thread Re: [Reena0330] "Owner" select field can only be changed to self
604 3039 Aug 13, 2002, 3:47 PM
Post Re: [TheStone] "Owner" select field can only be changed to self
Reena0330 3025 Aug 15, 2002, 1:03 PM