Please try simulate/reproduce using the following .sql files below.
SET FOREIGN_KEY_CHECKS=0;
-- Table structure for table1
DROP TABLE IF EXISTS table1
;
CREATE TABLE table1
(
Table1_Code
char(3) NOT NULL,
Description
varchar(50) DEFAULT NULL,
PRIMARY KEY (Table1_Code
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- Records of table1
INSERT INTO table1
VALUES ('001', 'Table1-001');
INSERT INTO table1
VALUES ('002', 'Table1-002');
INSERT INTO table1
VALUES ('003', 'Table1-003');
-- Table structure for table2
DROP TABLE IF EXISTS table2
;
CREATE TABLE table2
(
Table1_Code
char(3) NOT NULL,
Table2_Code
char(3) NOT NULL,
Description
varchar(100) DEFAULT NULL,
PRIMARY KEY (Table1_Code
,Table2_Code
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- Records of table2
INSERT INTO table2
VALUES ('001', '001', 'Table2-001 < Table1-001');
INSERT INTO table2
VALUES ('001', '002', 'Table2-002 < Table1-001');
INSERT INTO table2
VALUES ('001', '003', 'Table2-003 < Table1-001');
INSERT INTO table2
VALUES ('002', '004', 'Table2-001 < Table1-002');
INSERT INTO table2
VALUES ('002', '005', 'Table2-002 < Table1-002');
INSERT INTO table2
VALUES ('002', '006', 'Table2-003 < Table1-002');
INSERT INTO table2
VALUES ('003', '007', 'Table2-001 < Table1-003');
INSERT INTO table2
VALUES ('003', '008', 'Table2-002 < Table1-003');
INSERT INTO table2
VALUES ('003', '009', 'Table2-003 < Table1-003');
-- Table structure for table3
DROP TABLE IF EXISTS table3
;
CREATE TABLE table3
(
Table1_Code
char(3) NOT NULL,
Table2_Code
char(3) NOT NULL,
Table3_Code
char(3) NOT NULL,
Description
varchar(200) DEFAULT NULL,
PRIMARY KEY (Table1_Code
,Table2_Code
,Table3_Code
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- Records of table3
INSERT INTO table3
VALUES ('001', '001', '001', 'Table3-001 < Table2-001 < Table1-001');
INSERT INTO table3
VALUES ('001', '001', '002', 'Table3-002 < Table2-001 < Table1-001');
INSERT INTO table3
VALUES ('001', '001', '003', 'Table3-003 < Table2-001 < Table1-001');
INSERT INTO table3
VALUES ('001', '002', '004', 'Table3-001 < Table2-002 < Table1-001');
INSERT INTO table3
VALUES ('001', '002', '005', 'Table3-002 < Table2-002 < Table1-001');
INSERT INTO table3
VALUES ('001', '002', '006', 'Table3-003 < Table2-002 < Table1-001');
INSERT INTO table3
VALUES ('001', '003', '007', 'Table3-001 < Table2-003 < Table1-001');
INSERT INTO table3
VALUES ('001', '003', '008', 'Table3-002 < Table2-003 < Table1-001');
INSERT INTO table3
VALUES ('001', '003', '009', 'Table3-003 < Table2-003 < Table1-001');
INSERT INTO table3
VALUES ('002', '004', '010', 'Table3-001 < Table2-001 < Table1-002');
INSERT INTO table3
VALUES ('002', '004', '011', 'Table3-002 < Table2-001 < Table1-002');
INSERT INTO table3
VALUES ('002', '004', '012', 'Table3-003 < Table2-001 < Table1-002');
INSERT INTO table3
VALUES ('002', '005', '013', 'Table3-001 < Table2-002 < Table1-002');
INSERT INTO table3
VALUES ('002', '005', '014', 'Table3-002 < Table2-002 < Table1-002');
INSERT INTO table3
VALUES ('002', '005', '015', 'Table3-003 < Table2-002 < Table1-002');
INSERT INTO table3
VALUES ('002', '006', '016', 'Table3-001 < Table2-003 < Table1-002');
INSERT INTO table3
VALUES ('002', '006', '017', 'Table3-002 < Table2-003 < Table1-002');
INSERT INTO table3
VALUES ('002', '006', '018', 'Table3-003 < Table2-003 < Table1-002');
INSERT INTO table3
VALUES ('003', '007', '019', 'Table3-001 < Table2-001 < Table1-003');
INSERT INTO table3
VALUES ('003', '007', '020', 'Table3-002 < Table2-001 < Table1-003');
INSERT INTO table3
VALUES ('003', '007', '021', 'Table3-003 < Table2-001 < Table1-003');
INSERT INTO table3
VALUES ('003', '008', '022', 'Table3-001 < Table2-002 < Table1-003');
INSERT INTO table3
VALUES ('003', '008', '023', 'Table3-002 < Table2-002 < Table1-003');
INSERT INTO table3
VALUES ('003', '008', '024', 'Table3-003 < Table2-002 < Table1-003');
INSERT INTO table3
VALUES ('003', '009', '025', 'Table3-001 < Table2-003 < Table1-003');
INSERT INTO table3
VALUES ('003', '009', '026', 'Table3-002 < Table2-003 < Table1-003');
INSERT INTO table3
VALUES ('003', '009', '027', 'Table3-003 < Table2-003 < Table1-003');
Make sure you have already enabled "Grid Add" from "Table" setup of "table3"
Lookup Table settings for "Table1_Code" field of "table3":
Table name: "table1"
Link field: "Table1_Code"
Display field #1: "Description"
Lookup Table settings for "Table2_Code" field of "table3":
Table name: "table2"
Link field: "Table2_Code"
Display field #1: "Description"
Parent field: "Table1_Code"
Filter field: "Table1_Code"
Regenerate ALL the script files.
Try to add a single record using "Add Page", the dynamic selection list is working properly. When you are selecting "Table 1 Code", then the data in "Table 2 Code" field will be populated based on the selected item in "Table 1 Code".
Try also to add multiple records using "Grid Add Page", the dynamic selection list is NOT WORKING. When you are selecting "Table 1 Code", then the data in "Table 2 Code" field WILL NOT be populated based on the selected item in "Table 1 Code".