>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
I think it would be easier for you to set up local p-views or CursorAdapters and refresh them when you navigate to next record.
If it's not broken, fix it until it is.
My Blog