Ref multiple record and display Ref rows

[Espegg]

I would to ref in a column A multiple record from another table and then when for example I see a record that has multiple record related I would to see also the related record table associated to that record.

How could I proceed?

[Aurelien · Accepted solution]

Hi @Espegg 

---

@Espegg wrote:

I would to ref in a column A multiple record from another table

---

Let's say you wish, in table A, to pick multiple items from table B.

Set your column type with EnumList, then base type Ref, source table B, and in the Valid_if expression, write:

tableB[key-columnB]

Here is an illustration with an order made of multiple items: 

---

@Espegg wrote:

then when for example I see a record that has multiple record related I would to see also the related record table associated to that record.

---

In a virtual column, based from the previous example, use this expression:

The result will be: