Very Computer

  Is it possible to open two separate files, of different source formats, and
combine them into one display?

This is what I want to do;

  Incorporate a secure (read only) Foxpro database file and another database
file into common browse/update forms.  The Foxpro database is periodically
updated by office #1 but needed by office #2.  Office #2 uses #1's data to
create their own unique data.  I want office #2 to have read/write access to
their own data but only read access to the data from office #1.

  It's very desireable to be able to display the necessary combination of data
#1 and data #2 on the same forms.  The format of database #1 must be Foxpro,
but that of database #2 can be anything (e.g.: office #1 doesn't use data from
office #2).

  Is this possible using VB3?

thanks in advance.

Don Winiecki
Texas Tech University
College of Education

The simple answer is: yes.

If you don't have VB's Pro edition, you can do it with Data controls.  You can have as many data controls as you want
on a form, and each can point to a different database if you like.  The data control itself can be invisible.
Then you can put any number of label and/or text boxes on the form that point to specific fields within the database
that the data control is pointing to.

You can do some pretty neat stuff by putting SQL statements into the RecordSource property of the data control
and following it with a Refresh.

If you have the Pro edition of VB, you could also do more than one OpenDatabase and set up dynasets from it to
your heart's content.

I suspect that Crystal Reports, which comes with the Pro edition may be able to do what you want as well,
but I haven't had a chance to really study that one yet.

Hope this helps.

Reg Jacklin
Contract Programmer

please, pretty please...

Quote:> The simple answer is: yes.

Quote:> If you don't have VB's Pro edition, you can do it with Data controls.  You can have as many data controls as you want
> on a form, and each can point to a different database if you like.  

Quote:> Hope this helps.

Quote:> Reg Jacklin

John.

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>

President,
Raptor Systems
1813 Rugg Road
Nanaimo, BC V9R 5K2                           Tel: (604) 722-7041
CANADA!                                       Fax: (604) 756-6171