Search options (Page 27 of 34)

Thanks Dmitry,

for some reason, the "frxReport" works only on main form, I had to adapt the script to point to main form (SelectForm) so it looked like

SelectForm.frxReport.blablabla

I could manage 16 different reports on the same page which is the purpose of a database for me, getting dashboard reports in a snap. The report designer is just not very user friendly, though!

I have an error while transposing your example to my project, see attached picture

The last script does not work in 1.51.

Oh great! I think, this is something I could use to create some kind of wizard Thanks Dmitry

Please find a simple example with one Table Employee and one table logs.

To see and edit the triggers, you will have to use an external tool SQLStudio
Have fun!!

There is a very interesting solution in this topic: http://myvisualdatabase.com/forum/viewt … p?id=1484. Reply 13
You would not have to use any SQL query at all

Otherwise a join is done using a relationship field in the tables

For example

Author                                   Origin                                            Title
id                                           id                                                   id
Name                                    Country                                         Title
Title                                       id_Name                                       Year
                                                                                                   id_Name
                                                                                                   id_Country

Select Title, Country, Name

from Title,
Author a,
Origin o
where
id_Name=a.id
and id_Country=o.id
and Title=something

But honestly, the solution from derek is the simpliest one

Hi Derek,

the idea is there, thanks for the project.

The best would still be the "Wizard" mode where the user is guided through steps to limit input errors. I got feedbacks from the users after a beta release that there would be more tables, relations and fields needed...

It is very tricky actually to get multiple information which are linked by a key from different sources and display the required information separately.

It is much easier in a simple grid with an SQL query but here, the information must be displayed separately to get clear information on each level.

Please find a picture of what I mean by getting information from another grid automatically, the arrow indicates the source of the information (the key)

Another question is, how to query information using results displayed in a grid on same form? I already use the script to get the info from a textbox but here, I am stuck.

In short, how to get info in Grid 2 (query in table X) based on information stored in Grid 1 (using query in table Y) sharing an id.key in Grid 1

Grid 1                        Grid 2

A                               Blue
B                               Green
C                               Yellow
D                               Red
E                               Cyan

Thank you for the explanation Dmitry, much appreciated.