Information générale
Titre:
Referential integrity and grid in VFP 8
Hello.
I have two tables involved in a referential integrity relationship:
Parent: REGOPC
Child: NOMIDI
Parent TAG: CODIDI
Child TAG: CODIDI
Rules:
UPDATE: CASCADE
DELETE: RESTRICT
INSERT: IGNORE
This relation is based in the field CODIDI (Tags CODIDI in both tables).
In a grid, I have as RECORDSOURCE the table REGOPC, and in one column of the grid, I have this expression:
"Iif (Seek(codidi,"NOMIDI","NOMIDI"),NOMIDI.nomidi,Space(20))"
Where:
codidi - Field of the table REGOPC corresponding
to the TAG CODIDI in both tables.
This expression recover the field description from the table NOMIDI.
When I navigate in the grid with right or left arrow, and hit the column corresponding to the expression above mentioned, the grid is positioned in the first row. If I try to move down with down arrow standing in this column, impossible, it stays there. I move to another column with left/right arrow, and after that, I can move up and down.
The problem is in the mentioned column.
Can anyone help me ?
Thanks in advance.
Pita.
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