Subdatasheet comes and goes

[Marge]

I have two tables (roster and personal info) that have a 1 to 1 relationship
based on an ID#. The subdatasheet property of both tables is [Auto]. I have
a query (source: personal info table) with some (not all) information
displayed. I have many queries (source: roster table) that I want to add the
personal info query to as a subdatasheet (with the plus signs at the
beginning of each record). In design view, the roster queries have the
personal info table and the personal info query shown with their
relationships to the roster table. I set it up, save the query and when I
open the query later, the subdatasheet is not there...no plus signs. I don't
get it. Can someone give me the benefit of their thoughts?

 

[John W. Vinson]

I have two tables (roster and personal info) that have a 1 to 1 relationship
based on an ID#. The subdatasheet property of both tables is [Auto]. I have
a query (source: personal info table) with some (not all) information
displayed. I have many queries (source: roster table) that I want to add the
personal info query to as a subdatasheet (with the plus signs at the
beginning of each record). In design view, the roster queries have the
personal info table and the personal info query shown with their
relationships to the roster table. I set it up, save the query and when I
open the query later, the subdatasheet is not there...no plus signs. I don't
get it. Can someone give me the benefit of their thoughts?

I routinely set the Subdatasheet property of all tables to [None].
Subdatasheets are a major drag on performance and are never necessary! You can
use Forms (based on a join query, or with a form and subform) and Reports
(based on a join query) to display the data; query datasheets are of very
limited utility. Why do you feel that you need subdatasheets?

In addition one to one relationships are rather rare, and may not be
appropriate. What's in your Roster table? If it's really a one to one
relationship why not just put its information into the personal info table?