adorni
Posts: 120
|
| Posted: 04/23/2010, 4:48 AM |
|
When i try to make a Grid and Record, for the grid, i can put a "QUERY" (i see the option "QUERY BUILDER"), but, when i have to select and table for RECORD BUILDER, i canŽt put a QUERY, i only can select a table. How i can create a record builder for QUERY (for make change in differents tables)?
Thanks
|
 |
 |
CodeChargeMVP
Posts: 473
|
| Posted: 04/23/2010, 10:07 AM |
|
Quote adorni:
When i try to make a Grid and Record, for the grid, i can put a "QUERY" (i see the option "QUERY BUILDER"), but, when i have to select and table for RECORD BUILDER, i canŽt put a QUERY, i only can select a table. How i can create a record builder for QUERY (for make change in differents tables)?
Thanks
Hello,
I Think I can resolve your doubt,
If you want to work over two or more tables, youŽre on the right way,
Use the Grid and record engine and when youŽre on the visual query step
click on "Build query" and than an pop-up menu will appear with the whole
tables than you can choose, press shift to choose the tables and then
create the connections from primary key to foreign key from one to other
and then click ok, YouŽll automatically see all the fields from both tables.
Greets.
_________________
Best Regards
Entrepeneur | NT Consultant
|
|
|
|
|
