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
Try suspending the program, ACTI SCREEN, and then open BROWSE windows for all four tables. Select Table1 and navigate through it. If Table3 does not update properly then you probably have a problem with the way the relations were set.
If the BROWSE windows show properly, then my guess is that you have a problem with Refreshing the grids on the form. Make sure the AfterRowColumnChange method in Grid1 fires a refresh of all the grids. I would probably do that as the last step in the form's Init method as well.
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