Hi All,

I have 4 tables related.
The first table only holds the main primary key of the records being looked at.
The second table (sec_tbl) I have set relation to the first table on the main primary key. One to one match.

The third table (thi_tbl) is set to relationship with the second table on the primary key. One to many match.

The fourth table is set with a filter on the primary key in the third table. One to many match.

My problem is that my third table, which shows only one field (not the primary key) in a grid, is showing all of the records, even the ones that do not belong to the current primary key selected in the first table.

I thought, my third table grid only showed the records for that primary key, before I started experimenting on this form to narrow the list of primary keys.

Am I imagining things? Or what did I do wrong?


TIA,
Beth