Crotten
Posts: 12
|
| Posted: 09/27/2010, 11:37 PM |
|
My user table has an Int column that contains the numeric value of a user's access level. 1 = user, 2 = mgr, 99 = admin etc., there are some reasons for this to be like so.
I have another table that has the text for the appropriate levels, this table also contains other system specific data..
When I display a grid user record, I'd like to be able to display "admin" instead of 99 for user level (also change to font color if possible) and when editing a user, I can choose to list the Access Level from the system table (for example "admin"). I get a multipart error when trying to save the data.
I realize that I'm getting the error beause I think CCS4 is trying to put "admin" into an int column.
What am I missing - again wih a likely dumb question.
cheers.
|
 |
 |
|
