Unanswered: Can't query if multiple related tables are added.
I'm trying to do a query that would allow a user to type a SSN and it will display information for the person from different tables. If I just use the main table, works fine. If I add the related tables, which at the moment don't have that much information, it comes back blank.
It's as if it views the fields from the other table as an AND. I may totally be doing the query wrong, so that's why I'm here.
My goal is to do a report from the query so I have all my fields on the query. For some reason, I have a feeling this may not be good practice. I played around with just having enough fields to query and adding the additional fields on the report but that didn't seem to work.