hello,

i have table1(id1 PK) and table2(id2PK, a1, a2)

i want a1 and a2 to be foreign keys for id1 (with cascade on update & delete). making a1 foreign key works fine. when trying to make a2 foreign key as well, a 3rd table (table2_1) appears in the relationships window (but not in the db).

what does this behaviour mean?

thanks

This behaviour means exactly as you describe it...

the Table2_1 is a "simple" copy/alias of the same table, to be able to make the relationships work...

In actuality I think you want to have 2 table1's not table2's.

thanks for your answer, got it