Problem Linking three databases

[DianaStewart]

I have three databases.

Database 1 contains the LastName field
Datebase 2 contains the LastName field
Database 3 contains the LastName field

I am using Database 1 as my primary database. I link the LastName field from Database1 to Database2 and I link Database1 LastName field to Database3 LastName field.

How should I link these three tables?

Should it be DB1 LastName -> db2 LastName -> db3 LastName
or Db1 LastName to Db2 LastName -- db1 LastName -> DB3 LastName???

In the Edit Selection Formula, I have
{DB2.Date } >= {?Date1} and {DB2.Date } <= {?Date2} and
{DB1.Group} = {?Group}

If a name in DB3 is not between those two dates then the name does not appear... But technically I have Group1 grouped by DB1.Name, since this is the primary db then all names should appear regardless... what am i doing wrong???

 

[mbarron]

Try using a &quot;Left Outer&quot; join between Db1 and Db3.

use this linking:
Db1 LastName -> Db2 LastName (use the LeftOuter if there is data in Db1 that may not be in Db2)
Db1 LastName -> Db3 LastName

If this method doesn't work you may need to add the info in Db3 via a sub-repot. Mike