c:\Data\Inventory.mdb
        RawInventory            'Raw material inventory table
          PartNum               'Fields
          PartName
          Description
          Qty

        c:\Data\Supplier.mdb
        Supplier                'Supplier table
          PartNum               'Fields
          Name
          Address

To make the example easy, I want a record set with RawInventory.PartNum,
Supplier.Name, RawInventory.Name, RawInventory.Description.  How do I
specify the location of Supplier?

Ironically, many of the VB texts talk about table normalization, but
none (seen so far) describe how to get data from tables in different
files.  Anyone interested in writing a book?

Thanks in advance.
Dennis,

1) Create a linked table in DB A that points to the table in DB B. Then you
can write code as if both tables existed in DB A.

2) Use the IN clause of Jet SQL. I don't typically use ADO against Access
databases, so I'm not sure if it supports it, but DAO definitely does.

Set db = OpenDatabase("c:\Data\Inventory.mdb")
Set rs = db.OpenRecordset("select * from RawInventory, Supplier in
""c:\Data\Supplier.mdb"" where RawInventory.PartNum = Supplier.PartNum")