I'm having a hard time changing my report's current database to it's intended database.  It looks like doing the "Database/Set Location" thing I'm only able to select one table.  Is this correct?  Am I only able to select one table per subreport?  I need to be able to select two tables and no matter what sequence of "Set, Set Location, Done" I do, I can only select one table at a time per subReport.  Currently my report is working off of an Access Querry that is made up of two tables.  Now I need to point to the real database via an ODBC name and am having a one table limitation. If I select the invoice header table then I have unmapped fields that belong to the invoice detail table.  If I then do the set db thing to set the invoice detail table then I have unmapped invoice header fields.

 

 Can someone please tell me how to go about this?