Dependent ref from different tables

[CHRISTOPHE_CHAN]

Hi Guys,

Is there a way to determine what is the correct ref table of a ref column, depending from a previous choice ?

Example :
I have a 3 suppliers. I have 3 product tables, one for each supplier.
In my order table, I choose the supplier and then, the article column (ref) would show rows from the concerned supplier product table only.

I know the concept of filtering whithin a table but is there any possibility to manage a ref column like this ?

Thanks