Filter a Subform based on contact info on main form

[kevin_b]

Hi everyone. I just started using Access a couple of weeks ago and I thought I was getting a slight grip on it after multiple Youtube videos. However I ran into a problem that will be described below:

Database



I am trying to create a sample financial database to play around with and test it. Currently I have successfully displayed general information about the club, however when I try to display financial information about the club, it shows all financial records, not just the intended club. I feel like I am missing an Access relation here but I don't know where.

Steps to Reproduce:

Click the "Club Details and Input" Button on the main form.
Click the "Financial Information" tab.
Click the "Financial Board" Sub-Tab.

As you can see, it will show two inputs, one having to do with the club and one not having to do with it. Any help or guidance would be greatly appreciated.

-Kevin

[orange]

Kevin,
Welcome to the forum.
Your post has been approved, so now it is public.

I recommend that you adopt a naming convention that doesn't have spaces in field/object names. Use alpha and numeric chars only. It will reduce eventual syntax errors.
Review/research Normalization.

Goo luck with your project.

[Eugene-LS]

"Financial Board" Sub-Tab - Object "Child77" (SubForm) - Change LinkChildFields Property to "Club Name"

[kevin_b]

"Financial Board" Sub-Tab - Object "Child77" (SubForm) - Change LinkChildFields Property to "Club Name"

Eugene, thank you for the assist. It now works perfectly.

Orange, I will definitely look into the naming convention for Access, thanks for the heads up.