Getting a Subform to only show related information

[Delta223]

Hello,

I am trying to make a form using the following tables:

http://screencast.com/t/iuYJkmmw

I can create a form from the "Website" table and my "history" table will show up as a sub-form. This is what I want, because the history table is meant for storing notes

However, a 3rd table, not pictured, is used to make a query with the website table. No subform is created by default (bad) When I try to add a history table subform, the history data is not filtered against the currently displayed entry.

I know what the problem is: the subform is not filtering the data it displays based on the entry data. My question is, how can I get the sub-form data to link with the displayed entry?

Thanks

[pbaldy]

In the properties of the subform control on the main form (not the subform itself), you'll see Master/Child link properties.

[Delta223]

I have linked the matching field (in this case the website ID) However only one entry is now shown in the main form.

http://screencast.com/t/vsBLhXni7r

The main form had 3 entries. the Subform has matching entries for each.

Any idea why the main form is showing only one entry?

Thanks

[pbaldy]

Can you post the db here? I don't want to click on a link to a site I'm unfamiliar with.

[Delta223]

Unfortunately the database has some of my sensitive data in it. You don't have to click the image; I basically repeated all the relevant details in the post & just showed the image for clarity