I have lost my mind on this one.
I have used the inner join successfully on a portion of my site but I've run into a bit of a snag.
Tables & Fields
- Contains property information
[u]PropertyID</u>, [u]ContactID</u>, Address, Price.....
- Contains Contact Information which a person could be the contact for more than one property
[u]ContactID</u>, ContactName, ContactPhone...
- Contains property features which can contain multiple features for each one property
[u]PropertyID</u>, Feature, FeautreDesc...
I have been able to create the INNER JOIN for PropertyInfo & ContactInfo as shown below.
"SELECT PropertyInfo.PropertyID, PropertyInfo.ContactID, ContactInfo.ContactID, " & _
"PropertyInfo.MLSNo, PropertyInfo.StreetAddress, PropertyInfo.UnitNumber, PropertyInfo.City, PropertyInfo.State, " &_
"ContactInfo.ContactName, ContactInfo.ContactPhone1, ContactInfo.ContactPhone2, ContactInfo.ContactEmail, " & _
" FROM ContactInfo INNER JOIN PropertyInfo ON ContactInfo.ContactID = PropertyInfo.ContactID " & _
"WHERE (PropertyInfo.PropertyID LIKE '" & strPropertyID & "')"
Now I need to add the PropFeatures Table to the Query. When I do, it repeats the Property Information for each Feature in PropFeatures.