General information
Category:
Forms & Form designer
Environment versions
Network:
Windows 2008 Server
>>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 I don't figure something out shortly, I will be. This form is such a pain! :)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only