Applying constant variable from unrelated table

Hi All, I have the following issue: There are two not directly retalted lookup tables - "Vendors" and "Goods". They are related through the data table "Operations". Each vendor has its own del...