Hey there!
I had a question, not sure if its a relationship problem or perhaps how I set up my tables.
I want to run a query from 2 tables, (I have attached a photo of how I set up my relationships.) What I want to know specifically is: which resources is tied to a specific project - I currently have the ProjectID in my "resource" table linking to the ProjectID in my "project" table. However, when I run my query, I get the prompt, "Type mismatch in expression."
What am I doing wrong?
Your help is appreciated!