Foreign Key Dropdown with multiple Columns?

[expired user #9026]'s profile image [expired user #9026] posted 9 years ago in General Permalink
I'm having a Table with a column for a first name and a last name.
When setting up the foreign key, the dropdown previews only the first name.
Is this because first name is the first column after the primary key on the table containing the names? Or is it possible to display both first and lastname in the dropdown?

Thanks!
ansgar's profile image ansgar posted 9 years ago Permalink
HeidiSQL selects and displays the first text or varchar column from the source table, assuming that it contains some human readable value. There is no way of knowing which values you want to see there instead, so it takes the first available text column.

Please login to leave a reply, or register at first.