Hi! Got a small problem that I wonder if you can advise with? I'll use an example to try to describe it.
I try to create a composite foreign key in a child table - let's call it
distributor. In that table I use two columns
storename as the FK that references
town in one table and
It seems OK, but when I click on the
distributor, I am shown
storename values in the drop down; and when I click on the
storename column, I am shown
town values. It should be the other way round. This can be avoided by specifying the correct order of the columns if coding directly in SQL, but I can't seem to find a way to fix it in HeidiSQL.
Can you advise?