Need help linking data between multiple tables/forms

[CeruChick]

Hi there!

I am a girl guide leader trying to make a faster way to keep track of my unit's completed badge and program work. I have made tables for every area I need (I started with one table but it was too large to change into a form).

In total I have:

1 - Basic Member table (main information like their name and how many years they have been in, whether they are still in the unit, etc)
6 - Program area tables
7 - Interest badge tables

What I want to do is be able to "add/edit" members from the main form, then go to all the sub forms for their program and badge work -- problem is, I have no idea how to link them! :banghead:

Any help would be great! Just let me know what additional information you need.

I am using Access 2007-2010.

Thank you!

CeruChick

 

[Alansidman]

Look at this for a starter:

http://www.datapigtechnologies.com/flashfiles/subforms1.html

 

[CeruChick]

Thanks for that video! It really helped me put it all together. Now if only I could get the reports to all work lol