Do you mean Students & Parents?

Hi I just checked the video out it is not the one I was thinking about. But it is close. I will see if I can find it again.

There are 8 parts to that series (with an Extended Cut in Part 7). You will find it very useful.

Yes it is very useful and I have checked all 8 parts. I can make this work.

Access Expert Level 16, Lesson 3 says "Next, we'll deal with a very common problem that I get asked about all the time. You have a table with a child (let's say a school student) with multiple parents who may or may not live together. You need to be able to send separate mailings home to each parent. How do you handle this? I'll show you one technique using a make table query and an append query with two parents, then I'll show you another multi-table solution allowing for unlimited parents."