🚀 go-pugleaf

If you want to open Table "on the fly" do this:
Form.Query1.SQL="SELECT * FROM MYTABLE"
    or
Form.Query1.SQL="SELECT * FROM "+ sMYTABLE
    and
Form.Query1.Active=.t.

In your example you have to create two queries and change SQL string of
second query "on the fly"...
But may be you can play with the Filter property of the second query...

With best Regards,
Saveli Kossenko

Erich greiner wrote in message <34A487DB.225F@t-online.de>...
>New with VdB7 I have problems opening databases at runtime.
>Converting my application, I have a form which open a master table
>at page 1 for editing datas and also shows in a listbox the table
>names of related tables for selecting.
>At form page 2 I like to open this related table, selecting from a
>second listbox the reccounts to work on it.
>I understand that I have to use queries for linking tables to the
>form.
>Previously I stored the field content (table name) in a variable
>and used the makro operator "&" to open it, but this is not working.
>Anybody can help me?
>Thanks
>Erich Greiner