I have a many to many relationship, using an intermediate table to link two tables in a database. When I create the relations and watch the browse windows, everything seems to work fine. As I step from record to record in the first table, the intermediate table's browse displays the expected records, and the last table also displays only the expected records.

When I have my FORM running, however, with a grid pointing to the last table, it shows ALL the records. Is this normal behavior?

Do I need to create a VIEW and refresh it every time I go to a new record to make this work properly?

TIA