Currently the “Foreign key” field type allows to choose only 1 field for join condition.
However, there are cases when more than one join condition is needed to join two tables, e.g.:
select * from table1 as t1 join table2 as t2 on t2.field1 = t1.field1 and t2.field2 = t2.field2
This would be really useful.