I try to join two tables
In the joined table (SellType) there are 3 columns
Name, FaktorA, FaktorB
In the table (Orders), where I like to join the 'SellType' table I have also 3 columns
Sell, A, B (A and B are hidden, they are just used for some calculations)
I now like to have a dropdown in the column 'Sell' with the values of 'Name' from 'SellType' (got that work with join)
When I add or edit a column to 'Orders' I now like to choose the column 'Sell' from dropdown and add the correct values based on 'Name' = 'Sell' from 'FaktorA', 'FaktorB' to the columns 'A' and 'B' from the joined table 'SellType'