Tables relationship view

dorb's profile image dorb posted 3 years ago in General Permalink

Hello,

The program is really great but I'm missing something really important.

in Access I can see on the same view 2 tables that are connect by FK.

let's say Person Table and Orders table. so if i click on expand button I can see that person orders.

is it possible to do on HeidiSQL?

Cheers

dorb's profile image dorb posted 3 years ago Permalink

I added an image for better information. im basically referring to the option of having Subdatasheet

1 attachment(s):
  • 01-08-2021-15-52-30
ansgar's profile image ansgar posted 3 years ago Permalink

HeidiSQL does it differently. It just shows a drop-down with the foreign values if you edit a column with a reference.

dorb's profile image dorb posted 3 years ago Permalink

Yes, I am aware of it.

so no future planning of adding this feature?

ansgar's profile image ansgar posted 3 years ago Permalink

No, that's not planned. I'm sure the underlying VirtualTreeView component in HeidiSQL does not support such a nested table view.

But issue #156 is similar, and may be worth for you to take a look.

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