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 4731 Aug 8, 2002, 3:28 PM
Thread Re: [Reena0330] "Owner" select field can only be changed to self
jean 4566 Aug 12, 2002, 11:57 AM
Post Re: [jean] "Owner" select field can only be changed to self
Reena0330 4565 Aug 12, 2002, 1:29 PM
Post Re: [jean] "Owner" select field can only be changed to self
Reena0330 4564 Aug 13, 2002, 1:10 PM
Thread Re: [Reena0330] "Owner" select field can only be changed to self
604 4562 Aug 13, 2002, 3:47 PM
Post Re: [TheStone] "Owner" select field can only be changed to self
Reena0330 4547 Aug 15, 2002, 1:03 PM