Generating Listbox In Results

[Erich]

I am trying to find a way to generate a dropdown list of items from a table in the results pane, similar to how the results look in edit mode for an enum field. Consider:

select

Resorts.ID,

Resorts.Name,

Resorts.Description,

Resorts.OwnerID,

ResortManagers.CompanyName,

Resorts.City,

Resorts.Region,

Places.Name

from

Resorts

left join

ResortManagers

on

ResortManagers.ID = Resorts.OwnerID

left join

Places

on

Places.ID = Resorts.Region

where

ResortManagers.CompanyName = 'Foo' and

Resorts.State = 'MA';

I would love to be able to generate a list of Places to select for each record. Is there a way to do this in the gui?

[peterlaursen]

I am not sure that I understand “dropdown list of items from a table”

If you mean restricting the column content to certain values the answer is only when the data type is ENUM or SET.

SQLyog does not store information obout the databases.  It queries the server.  If SQLyog did store some other client might change the data in the database and the information stored by SQLyog would become obsolete.

If you mean that the column `PLACES` itself shall be replaced with another column then the Query Builder that will sh

p sonn will be able to do this.

[Author]

Posts