I want to set two Ref datas from two tables.

Hi, all.

I have the below 3 tables. These are for “Stock control app”.

Pleaese check below drawing.

Usually, we can set "Ref " from one table, but I don’t know the two tables are settable or not.

Or, are there other way to solve it?

Thank you.