hey guys i'm just curious. in the relationships table i can add both tables and queries to the canvass.
1) can i create a relationship from a query to a table or i can't, it's just there for me to visually see the select query?
(i tried creating a relationship from the select query to the table but the below is what it shows me)
2) i've heard about views. is a select query a view? so all my select queries in access are views right? if they're not, what's the difference between a view and a select query? thanks!