What I am trying to do is create a generic ContactInfo table that has a field of ContactType to tell what type on contact it is, and then link to that table from a query where I only want a specific ContactType (in this case, 1). I thought the following join statement would work, but it seems to ignore that part of the statement.
FROM ContactType RIGHT OUTER JOIN
ContactInfo ON ContactType.ContactTypeID = ContactInfo.ContactType AND ContactInfo.ContactType = 1 RIGHT OUTER JOIN
CustAddr ON ContactInfo.CustNum = CustAddr.CustNum
Anybody know what I am doing wrong? Thanks!