Forums

Hi, I am trying to see specific fields from different tables. How would I can do thi, please? I tried Multi-table option in Connection, but failed. Thanking you. Raihan

Hi Raihan,

Either you work through the FAQ on linking more than one DB Multi-Record loader (it does work but is not the easiest thing in the world to get right); or you hand code a MySQL query to do exactly what you need - which is probably what I would do.

Bob

Thnx Bob.
I do wish to do the same, just to use the code. I know a bit about mySQL. But can't catch, how and where I should use these codes.

I tried the FAQ, DB Multi Record Loader. The example there don't have the sample table, with Field Name. So, It was not much clear to me.

For example: C1 table have ID, Name, Phone; C2 table have ID, Email, Address. Now, I wish show all Name in a combo box. Then whichever name selected another textbox will show the corresponding Email. Please help me.

Thanking you in advance.

Raihan

Hi Raihan,

For example: C1 table have ID, Name, Phone; C2 table have ID, Email, Address. Now, I wish show all Name in a combo box. Then whichever name selected another textbox will show the corresponding Email

What you are describing here is a double drop-down, that is a different question that the earlier one. Please see this FAQ which may help.

Bob