Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement