Relationship problem after appended data

Greetings~

Current situation: I had a nice relationship going between my query and 2 reference queries where I filtered for variables in the same column. This was so that I could create a calulated column in my report. Before I appended my data with date from other years, this had all worked! With the relationship between the two tables being "one to many". Now that there are more years, my relationship is spoiled!  How do I fix this?