I have a 2003 db with multiple tables that all refer to each other.  My
tblStoreData has fields like StoreNumber, StorePhone, StoreName, OwnerID,
RegionID, DistrictID that contain numerical values that correspond to data
in other tables like tblOwners which has OwnerID, OwnerName; tblRegion which
has RegionID, RegionName; tblDistrict which has DistrictID, DistrictName.

What I'm trying to do is print a report that has all of this data on it. I
have my report designed and semi working, I have an inner join pulling the
OwnerID's together so it shows the Owner's Name on my report.  I think I
need to keep doing inner joins to add the RegionName and DistrictName, but I
just can't seem to make it work.

Here's the code I have that pulls the owner's data into the report:

strSQL = "SELECT * FROM tblStoreData INNER JOIN tblOwners on
tblStoreData.OwnerID = tblOwners.OwnerID"
Me.RecordSource = strSQL

I want my report to show this data:
Number    Name                            Owner
Phone                            Region                District
123        Alpha Store                    Joe Blow Owner
123-456-7890                Central                Mountain

Thanks!

Darhl