Using Multivalued Fields In Queries. The conventional way is to model the relationship type by a separate table which resolves it in two one-to-many relationship types. The selected items are stored in the multivalued field and are separated by commas by default when displayed.
When you create a Lookup field a join is created between. It wont take long. These 3 examples are all equivalent.
The query in question works in the original database but when I import it into a new database file the Union query does not work.
When using docValues an optional 2nd argument can be specified to select the min or max value of multivalued fields. Drag the multivalued field and its single value field to separate columns in the design. For filtering result using the expand method above you can use INNER JOIN with another table that contains the value you are looking for. I am trying to build a simple Query that concatenates the display value of a multivalued lookup field with other Text fields from the same Table.