Hi Rick!  I have another question and unfortunately not as educated as Chris, so I am scared to mess with my DB too much.

With regards to Lesson 14 & 15 of seminar - Org & Members.  I deleted a member from the memberF, which also did the deletion to the memberT.  However on the OrgXMemberSubF (now shows a blank space), the MemberXOrgSubF (still shows the org), and the OrgXMemberT (Still contains all of the data).

I have already tried several things, none to which have worked. I went to add DB relationships for the OrgT, MemberT, and the OrgXMemberT - but apparently have not picked the right choices and I am now really confused.

I also built a DB for my books - AuthorT, BookT, SeriesT, and BookXAuthorT - Unfortunately the same thing happened.  (Of course an AUTHOR can have more than 1 book & create more than 1 series - A BOOK can have more than 1 author & it can belong to more than 1 series - A SERIES can have more than 1 author & has more than 1 book - Which is why I used a JunctionT)

ie) Series A, has Book 1, 2, 3
ie) Series B, has book 4, 5, 6 which are also the same books as in Series A, Book 1, 2, 3.

Can you please help?  Thank you in advance!

P.S.  I really loved this seminar especially lesson 14 & 15.  I love that you can have multiple relationships and these sub forms that shows you the information pertaining to only that person.  I ABSOLUTELY LOVE IT!

IE) Have PersonF (with specific data like DOB) and then sub forms that show the organizations, Other groups, Address, Phone numbers, Supervisors, Contact Notes etc.  Then Have OrgF (with specific website and email) and then sub forms showing the people, Address, Phone numbers, and contact notes!!!

---

Reply from Richard Rost:

Did you have referential integrity set up?