Forum Discussion
LOOKUPVALUE error
Ok
then try
MAXX (
RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )
Great
would you please answer the question at end of my previous reply
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.
Actually no. What I mean is that there is no single value for the ID. Retrieving the ID in the the field values table will result in a table rather than a single value. Therfore, you have to provide a preference on which on of the ID's shall be selected. Unless you are sure that this table actually contains duplicates of the same ID.
I am sorry but I am not following what you are asking for.
I am trying to use the field_values[id] in the field_values table and look up that on the field_value_choices table were
field_value_choices[field_value_id]and return the
field_value_choices[field_choice_id]I am using a calcualted column so there should only be 1 field_values[id] at a time.The new column will be in which table?