Is there a way to determine what is the correct ref table of a ref column, depending from a previous choice ?
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 ?