I have two tables, Table 1 and Table 2.
I want to create a link between them, 1:n.
The problem is that I want to create a foreign key on Table 2 where:
Table2.Field1 = 1 (some static value)
Table2.Field2 = Table1.Field1 (PK)
Is this possible and if so, how would I do it?