General information
Title:
Problem with GRID and SET RELATIONs
I have found a strange problem with GRIDs and SET RELATIONs.
Suppose I have a table with fields KEY_A and KEY_B, which are foreign keys in TABLE_A and TABLE_B respectively. I want to set up a grid showing KEY_A, TABLE_A.NAME_A, KEY_B, TABLE_B.NAME_B, and be able to add new records with a command button.
I set all this up in the data environment of the screen, but when I add records, I get strange behaviors: either a RECORD OUT OF RANGE error message shows up, or wrong NAME_A o NAME_B values appear.
If I set up a grid with only ONE relation, the grid works fine, but when I try to work with two or more related tables, I cannot get it to work.
Does someone know what this is all about? Is there a patch, a fix or a workaround for the problem?
Thanks!
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