Forum Discussion
Solved
LOOKUPVALUE error
I am getting the "A table of mulitpule values was supplied were a single value was expceted." I am trying to look up the field_value_choices[field_choice_id] based on the field_values[id] This form...
Ok
then try
MAXX (
RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )
so basically what I am trying to have show in the Employee type column is - this is the field_values table
take the id 89088567
look on the field_value_choices table - match the id to teh field_value_id and return teh field_choice_id - 160597
It does appear there are duplicate values in the field_value_id column as there are 7,444 rows but only 6,315 distinct values.
Ok
then try
MAXX (
RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )
That worked when I changed it to
MAXX (RELATEDTABLE ( field_value_choices ), field_value_choices[field_choice_id] )