Prev: Auto load cd
Next: how do i create subdata form in access
From: Lars Brownies on 16 Apr 2010 11:31
When making relationships in the relationship window does it matter which
join type you choose? I'm always doubting between the following two, as in
my queries I sometimes need one and sometimes the other:

1. Only records of which the linked fields are identical.
2. All records from the main table and only the mathing records from the
child table.

Somehow I think it has no effect on the referential integrity, it will only
be a default relationship in queries. Is my assumption right?

Thanks,

Lars




From: Dirk Goldgar on 16 Apr 2010 11:41
"Lars Brownies" <Lars(a)Browniew.com> wrote in message
news:hq9vt7$2u1i$1(a)textnews.wanadoo.nl...
>
> Somehow I think it has no effect on the referential integrity, it will
> only be a default relationship in queries. Is my assumption right?


Yes.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: Lars Brownies on 16 Apr 2010 15:36
Finally I know. :-)
Thanks.

Lars

"Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> schreef in bericht
news:uPkpRtX3KHA.1016(a)TK2MSFTNGP02.phx.gbl...
> "Lars Brownies" <Lars(a)Browniew.com> wrote in message
> news:hq9vt7$2u1i$1(a)textnews.wanadoo.nl...
>>
>> Somehow I think it has no effect on the referential integrity, it will
>> only be a default relationship in queries. Is my assumption right?
>
>
> Yes.
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>
 | 
Pages: 1
Prev: Auto load cd
Next: how do i create subdata form in access