>>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.

This is what I have ended up doing. Thanks for the help.
Beth