Associate to a ref column multiple fields

[Espegg]

I have in my table a two ref dropdown field (Dropdown 1) (Dropdown 2) that takes the sellers tables.
Now, I have other 2 tables:
Colors, Food.

I would associate for both (Dropdown 1) (Dropdown 2) two sellers and for each one (the sellers) Colors or Foods.

So, the question is, could I call with a Ref column or Enum/Enumlist column, two different tables?

[Espegg]

So, the question is, could I call with a Ref column or Enum/Enumlist column, two different tables?

[AleksiAlkio]

I don't see any reason why you could not do that. I would use Enum/Base type of Ref to avoid multiple virtual columns if they are really not needed.

[Espegg]

Hello, it is clear, but how could I associate to one enum/base ref column, two different tables? 

[Espegg]

@AleksiAlkio Consider also that I would associate the key values of the 2 tables

[AleksiAlkio]

Okay, that changes the situation. You mentioned "Sellers" and the image showed the same 🙂

[Espegg]

@AleksiAlkio so how could I associate to one enum/base ref column, the key values from two different tables? 

[AleksiAlkio]

That's not possible as you need to select the reference table.

[Espegg]

There is not any workaround?

[AleksiAlkio]

Are you able to use without Ref?

[Espegg]

The goal then is to have the references (sellers) to the other two tables "colors" and "food", and so in my dropdown I could associate one "color" and/or one "food" to that seller

[AleksiAlkio · Accepted solution]

Without using the Ref, you could create your own virtual list column if the inline view is something that you are looking for.