General information
Title:
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.
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