Not sure if this is possible, but can a lookup field on a form also be also used to store free text? I have a table where some phrases are stored, and its three columns are named as such:
Code EnglishPhrase FrenchPhrase
I use these phrases on a report, based on a Code I assign to a certain characteristic for a product. My stumbling block is that some characteristics could be either numeric or linked to a phrase. For example, if the characteristic is "Height", I would like be be able to enter either a numeric value, or a Code that would link to a phrase. The Code would be something like "n/a" and the associated English and French phrases to appear on the report would be "Not Available" and "Non Disponible".
While I can create records for each number as a Code (ie, a record where "Code" = 23, "EnglishPhrase" = 23 and "FrenchPhrase" = 23), this seems like a very poor design. Does anyone have suggestions on what to do in a case like this?
Thanks for all the help!
Code EnglishPhrase FrenchPhrase
I use these phrases on a report, based on a Code I assign to a certain characteristic for a product. My stumbling block is that some characteristics could be either numeric or linked to a phrase. For example, if the characteristic is "Height", I would like be be able to enter either a numeric value, or a Code that would link to a phrase. The Code would be something like "n/a" and the associated English and French phrases to appear on the report would be "Not Available" and "Non Disponible".
While I can create records for each number as a Code (ie, a record where "Code" = 23, "EnglishPhrase" = 23 and "FrenchPhrase" = 23), this seems like a very poor design. Does anyone have suggestions on what to do in a case like this?
Thanks for all the help!
