Relationship issue when updating

[dbero]

I have a db that uses radio buttons, with the option values stored as values 1,2,3,etc. This of course is linked to a translation table to define the integer.

However, I now want to go back and update a record because a person entered a wrong value in the radio button. And of course i can't update the table while it's related to the translation table, but I don't want to have to know that a 1 means house, and 2 means apartment, etc. Any quick suggestion on this?

thank you!

 

[lespaul]

why can't you update the record?

UPDATE TableName Set FieldName = 3 WHERE PrimaryKey = Identifier



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design