Relationships should be done in the database containing the tables. In your case, the backend.
if you apply relationships in the frontend, they are purely 'cosmetic' and referential integrity cannot be enforced.
I opened up to review your relationships. I don't have the MSys relationship stuff.....what is that? I created the relationship around the DataEntry only.
FANTASTIC.....thanks so much for your assistance. I went through your queries and I found what I was missing. I created a relationship...then added the description to the query and it worked like a charm.