To make it a Left outer join, you would add 16777216 to the Attributes
bit field. For a Right outer join, you would add twice that: 33554432
I wasn't able to find this documented in the help file, so I just
fooled with some relations and checked the effect on their attributes
property.
-- Andy
Quote:
>Hello everyone,
>In Access 97 SR-2 I have VBA copy two tables and create a relationship
>between them with CascadeUpdate and CascadeDelete enabled. The problem
>is that I need the Join Type to be Left, not Inner. How do I accomplish
>this in my module.
>Thanks for any help.
>Cindy Rovell