References to a Lookup List

Question

I have a lookup list for density/consistency that has two columns - "Text" and "Description" . The "Text" is the lookup list (e.g. VSt) "description" is just be a prompt for the data inputter (e.g. Very Stiff).

The log currently outputs the contents of <<CONSISTENCY.text>> which is poulated by the inputter via a drop down menu from the "Text" column of the lookup. I want the log to lookup this value and output the corresponding "Description" of the lookup.

Do fields in lookup lists have the equivalent of <<TABLE.field>> format used for library data tables?

I could use an if-then statement in the report text expression field but I would need 22 of them so I would rather use lookup "CONSISTENCY LOOKUP LIST.text" return "CONSISTENCY LOOKUP LIST.description"

Thanks

Kathleen Holcomb · Answer

Hello Coelodonta, 
 
This is a good question. I believe you are asking about using the Lookup function with a lookup list? Sorry, but the Lookup function does not work with lookup lists. Yes, you certainly could write if-then statements for each entry in your lookup list, but, as you note, you would need a LOT of conditions. Create a library table and move your lookup list data to the new library table so that you can use a Lookup function.

Kathleen Holcomb · Answer

Hello Coelodonta, 
 
I had forgotten the option to copy a lookup list to a library table! Thanks for mentioning it. 
 
You want to show LIBTAB_CONSISTENCY.Text in your Input field? Yes, you would need a gINT Rule to do that.