Autopopulate Number Field

[dashingirish]

I'd like to know if I can autopopulate a numeric field in a table based on the text in another field.

For example, TblMain contains two fields: Status and Value.
Status field is listbox of values such as Yes and No.
I'd like to automatically populate Value field with a number based on the value selected in Status, say Yes = 5 and No = 3.

Is this a reasonable thing to do and will it give me agita down the road when running reports and such? If it's reasonable, how would I do such a thing?

 

[tehNellie]

It has the potential to cause you problems, what if the "yes" value in table one becomes a "No" value.

It would be preferable to use a query to provide that number. If you know that Yes = 5 and No = 3 why store it again?

 

[dashingirish]

Thanks for the quick response. I agree it could be a mess down the road. Thanks for doing the thinking for me!