"Larry H" <larryh@appliedimage.com> wrote in message
news:94prg2$s2e$1@nnrp1.deja.com...
> I have a report with fields from 2 tables in a ONE to MANY
> relationship. They derive their data from a query, this ONE to MANY
> relationship is also defined in the relationships window.
>
> The problem I have is that some of the "ONE"s have no "MANY"s
> associated with them. In such cases, those "ONE"s don't come up in the
> query or report at all. (I hope the terminology hasn't befuddled you
> yet [SMILES].) I tried editing and deleting the relationship in
> the "relationship" window as well as the query as well. No matter, the
> problem continues.
>
> (PS--if I remove the relationship in the query AND the relationship
> windows, thousands of duplicates appear.)
>
> Any solutions here?
>
> Larry R Harrison Jr
>
>
> Sent via Deja.com
> http://www.deja.com/
Subject: Re: One to Many, Showing All the ONES if no MANYs
Date: 01/25/2001
Author: Dirk Goldgar <dirk@NOSPAMagcsys.com>
<< previous in thread · next >>
Check the join type of your query. It should be an outer join, such that it
includes all records from your "one" table and the matching records from the
"many" table. It sounds like you've currently got an inner join.
--
Dirk Goldgar
(remove NOSPAM from reply address)