[AccessD] Parent Child question

I feel much better now Debbie. THANKS

Joe Hecht
jmhecht at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Elam, Debbie
Sent: Wednesday, January 04, 2006 3:13 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Parent Child question

If you have X parent records and each parent has one child
record, you have
X parent records and X child records.  If you add a parent
to this set
without a child you have X+1 parent records and X child
records.  The two
sets of records must be counted separately since the numbers
of records can
vary drastically in most databases.  Does this answer the
question?

Debbie

-----Original Message-----
From: Joe Hecht [mailto:jmhecht at earthlink.net] 
Sent: Wednesday, January 04, 2006 5:02 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Parent Child question


If there is a parent record but no child data entered is it
right the count of records is different?

 

Joe Hecht

jmhecht at earthlink.net

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may
be: (1) subject
to the Attorney-Client Privilege, (2) an attorney work
product, or (3)
strictly confidential. If you are not the intended recipient
of this
message, you may not disclose, print, copy or disseminate
this information.
If you have received this in error, please reply and notify
the sender
(only) and delete the message. Unauthorized interception of
this e-mail is a
violation of federal criminal law. 
This communication does not reflect an intention by the
sender or the
sender's client or principal to conduct a transaction or
make any agreement
by electronic means.  Nothing contained in this message or
in any attachment
shall satisfy the requirements for a writing, and nothing
contained herein
shall constitute a contract or electronic signature under
the Electronic
Signatures in Global and National Commerce Act, any version
of the Uniform
Electronic Transactions Act or any other statute governing
electronic
transactions.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com