Ok I give up!  I am wasting my weekends trying to figure this out and I can't seem to make it work.

I have tried various ways to add ref integrity to my database and I got some of it working but then other parts didn't.

I am trying to set up a database just like this lesson with OrgF having Members, address, contact notes, phone number sub forms.  Same idea for MemberF.

I had it working so that if I deleted a member or org the junctionT information deleted as well.  However the address and contact note information was not deleted.

Then I found the video where chris was asking about cascade deletes where 3 people had the same address and tried to incorporate that too.  When I tried to add an org, I got a message come up regarding integrity.

Obviously I am seriously screwing up the relationships in my db and I need to know how to do it right!  I have:
- OrgT (OrgID, AddressID, PhoneID, ContactID)
- OrgXPersonT (ID, OrgID, PersonID)
- PersonT (PersonID, AddressID, ContactID, PhoneID)
- AddressT (AddressID, OrgID, PersonID)
- ContactT (ContactID, OrgID, PersonID)
- PhoneT (PhoneID, OrgID, PersonID)

I tried to do left joins - type 2 for the OrgT, PersonT to the junctionT and it worked.  

But when I tried to follow the video for address, phone, and contact notes, I couldn't add the address etc information to OrgF.  I had left joins for AddressT, PhoneT, ContactT to OrgT and PersonT with joint type 1.

Can you please tell me what my relationships should like and what join type to use for each as well?