Avatar of BBlu
Flag for United States of America

asked on 

Simple question about parent/child relastionships in Access

I have two tables, Problems_and_Bugs (parent) and Notes (child) that are joined in the Relationships window via a one to many join from the parent Primary key (to the child foreign key).  When I open the Problems_and_Bugs Table I can see those fancy "+" signs that allow me to expand and see the related Notes records.  

However, when I run a query on this, I lose that functionality.  Can anyone tell me how or why?


Microsoft AccessSQL

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon