Forum Discussion

mhawkinsCU's avatar
mhawkinsCU
Frequent Visitor
4 years ago
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...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Ok

    then try

    MAXX (

    RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )

mhawkinsCU's avatar
mhawkinsCU
Frequent Visitor
4 years ago

I have no relationships between these two tables. 

tamerj1's avatar
tamerj1
Community Champion
4 years ago

mhawkinsCU 

Sorry for the late reply. 
If possible please create a relationship between 

field_value_choices[field_choice_id]

and

field_values[id]

and let me know the cardinality and the crossfilter type you get. 
based on that we can retrieve values using RELATED or RELATED table. 
In case you have multiple 

field_value_choices[field_value_id]

for each field_values[id] then you have to advise which one of them should be retrieved 

  • mhawkinsCU's avatar
    mhawkinsCU
    Frequent Visitor
    4 years ago

     

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Great

      would you please answer the question at end of my previous reply 

      • mhawkinsCU's avatar
        mhawkinsCU
        Frequent Visitor
        4 years ago

        If you are asking about the Cardinality and crossfilter type that is why included the Edit relationship details in the picture.

        It is many (field_value_choices) to 1 (field_values), Cross filter direction is single.