BBlu
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?
Bobby
ASKER
My man DatabaseMX. Thanks. Can you point me to a tutorial on the best way to show these related records together whether in a query or form/subform format.
"whether in a query or form/subform format. "
Well, not in a query .. but ... that what the Form/SubForm paradigm does ... Master/Child ... Main Form - Single Form view, SubForm ... Continuous (or Datasheet) view ... using Link Master/Child properties.
No ?
mx
Well, not in a query .. but ... that what the Form/SubForm paradigm does ... Master/Child ... Main Form - Single Form view, SubForm ... Continuous (or Datasheet) view ... using Link Master/Child properties.
No ?
mx
ASKER
I think that approach would work. I'm still green when it comes to forms, though..do you know where there is a writeup on that..or can you give some basic steps?
You mean Form/SubForm doing the One to Many Relationship ?
mx
mx
ASKER
Yes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, DatabaseMX
You are welcome ...
mx
mx
http://allenbrowne.com/bug-09.html
Scroll down to 'Tables: SubdatasheetName'
Be SURE this property is set to None for ALL tables, both in the FE and BE.
This makes an AMAZING difference when linking for sure.
*******************
mx