1 (edited by tcoton 2015-10-12 11:53:19)

Topic: Querying two different values using table relationship

Hi everybody,

I know how to perform what I am looking for using a SQL Query but I wonder if there would be an easier way to do it using only MVDB internal engine.

In one of my project, I have a table which must contain 2 columns with different values but using a "dictionary table" to avoid data redundancy and I would like to display the value instead of the "id" in my query (see attached picture).

For instance, my table "Ports" has id_VLANS and id_VLANS1 referring both to table VLAN but I cannot figure out how to display the proper VLAN_ID for each using default tools. To do so, I would need a "join" feature in the properties...

The idea is to display only the VLAN_ID for id_VLANs and id_VLANS1.

This project is developed using 2.03 alpha.


http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=1394

Post's attachments

Attachment icon double_id_vlan_issue.png 163.22 kb, 328 downloads since 2015-10-12 

Re: Querying two different values using table relationship

Hello,


Please download the example:

Post's attachments

Attachment icon Combobox test2.zip 5.25 kb, 462 downloads since 2015-10-12 

Dmitry.

3 (edited by tcoton 2015-10-12 12:27:20)

Re: Querying two different values using table relationship

Hello Dmitry,

thanks for fast reply, this is kind of an intricate solution but as long as it works smile


And it works actually big_smile