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