Referential integrity and join type

L

Lars Brownies

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
 
D

Dirk Goldgar

Lars Brownies said:
Somehow I think it has no effect on the referential integrity, it will
only be a default relationship in queries. Is my assumption right?
Click to expand...


Yes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referential Integrity in Queries 1
Referential Integrity Unavailable 2
Referential Integrity Problem 9
Referential integrity settings 5
Referential Integrity doesn't work - Acc07 6
Newbie - Referential Integrity problems 2
referential integrity and possible orphans 2
Wrong message with cascading deletes 13

Top