Simple question about parent/child relastionships in Access

BBlu
BBlu used Ask the Experts™
on

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


Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Actually, you *WANT* to lose that functionality.  Please review the article below as to why:

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

Author

Commented:
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.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
"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
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Author

Commented:
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?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
You mean Form/SubForm doing the One to Many Relationship ?

mx

Author

Commented:
Yes.
Database Architect / Application Developer
Top Expert 2007
Commented:
Sure ... here are two examples:

Access Master/Detail Continuous Form
Continuous Forms for Master and Detail Forms
http://www.blueclaw-db.com/access_continuous_form_subform.htm

Create a form that contains a subform (a one-to-many form)
http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx

mx

Author

Commented:
Thanks, DatabaseMX
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
You are welcome ...

mx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial