2 database problems

[Leeper77]

ok here is my problem. I have 2 databases and I have a form that is going to be used for personal inventory file. they will select from one or both databases and put it into a third database how about do i do this? Any Suggestions?

Thanks

[JHausmann]

You can open multiple databases in your program.

[Leeper77]

how?

[HarryW]

If you've got 3 databases, you can use 3 data controls.

[Leeper77]

so there is no way except for putting 3 data conntrols in there to access those databases as one

[MartinLiss]

Here is an example of opening two databases using DAO

    'Open the databases
    gsRWTSPath = App.Path + "\data\rwts.mdb"
    gsRWTUPath = App.Path + "\data\rwtu.mdb"
    Set gdbRWTS = Workspaces(0).OpenDatabase(gsRWTSPath)
    Set gdbRWTU = Workspaces(0).OpenDatabase(gsRWTUPath)

Both gdbRWTS and gdbRWTU are dimensioned as Public Database.


------------------
Marty