General information
Category:
Forms & Form designer
Title:
Child / grandchild relation not working?
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
Next
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