Hiding 'criteria-ed' records in table

[buckyballe]

Hello All,

My main table also contains an attached sub-table. Meaning I have a table with adult names as records and the sub-table attached to each record are the childrens names for each adult name. "There is a "+" sign in the far left column that opens when clicked to reveal the childrens names for each adult record. About 30% of the main adults table contain names that are no longer relevent but should remain in the table. The records that are no longer relevent have quit and a column named 'quit' exists in the adult table. I'd like to hide those records when I open the Adults table. I know I can create a query in order to set the criteria to eliminate those non-relevent records but the query won't also show the sub-table like it does in the Adults table. Maybe the answer lies in creating a query that can also display the childrens sub-table like it does in the adults table? How do I make a query that acts like my main table, that contains the sub-table?

Bucky

 

[CautionMP]

buckyballe,
You are refering to subdatasheets, create your main query with the relevent filter then modify the suddatasheet name/link child/link master fields in the queries properties.

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[lespaul]

I think bucky is talking about lookup fields in tables....only mentions table, nothing about forms (which is where I would expect to hear a mention of subdatasheets).

I would recommend you read The Evils of Lookup Fields in Tables and modify your design if possible.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[CautionMP]

lespaul,

"There is a "+" sign in the far left column...

This is a subdatasheet, not a lookup. If you expand the plus sign you see a table within your table.

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[buckyballe]

I believe this is indeed a subdatasheet. I've successfully created the query and subdatasheet I need. Thanks for your help.

Todd