Salah satu hal dari sekian banyaknya fitur yang sangat saya senangi di PHPMaker adalah kemampuan untuk menghasilkan Combobox yang ketika salah satu data di dalamnya terpilih, maka data di Combobox yang terkait lainnya akan otomatis menyesuaikan berdasarkan data yang terpilih di Combobox sebelumnya. Di PHPMaker, hal ini dikenal dengan istilah Dynamic Selection List.
Tentu saja saya menyukai fitur ini karena beberapa alasan. Pertama, Web Developer diberi kesempatan yang sangat mudah dan cepat untuk mendefinisikan beberapa parameter yang terkait dengan fitur ini melalui tab Fields. Kedua, fitur Dynamic Selection List di PHPMaker tidak membatasi kedalaman level Combobox yang saling terkait ini, artinya: Web Developer dapat bebas menerapkan berapapun jumlah Combobox yang saling terkait tersebut. Dan yang ketiga atau terakhir, fitur ini juga memiliki pilihan apakah Anda ingin menggunakan AJAX untuk mengambil data di Combobox tersebut.
Fitur ini biasanya diterapkan pada Field yang datanya Lookup ke Table lain. Karena PHPMaker sudah menetapkan beberapa parameter supaya fitur ini bisa digunakan secara optimal, maka ada beberapa hal penting yang harus Anda ketahui/perhatikan sebelum menerapkannya di Aplikasi Web yang akan Anda bangun. Apa saja itu? Simak uraian berikut selengkapnya.
Pertama, jika Anda menggunakan kedalaman hirarki lebih dari 4, maka pastikan di setiap Table Lookup (kecuali di Table level pertama atau yang berperan sebagai induk utama) memiliki field yang menyimpan data Parent atau induknya.
Kedua, jangan pernah sekali-kali menggunakan Kode yang berulang di sebuah Table Lookup. Artinya, Kode utama di Table Lookup harus bersifat unik atau disarankan kode yang berurutan (Increment), meskipun beberapa Record pasti ada yang memiliki data Parent yang sama.
Ketiga, selalulah mendefinisikan Primary Key (PK) di setiap Table Lookup untuk mencegah terjadinya duplikasi data.
Keempat, untuk setiap Field Lookup tersebut, maka Anda cukup mendefinisikan field Parent dan Filter hanya pada Parent/Filter #1 yang terdapat di panel Lookup Table di bawah menu tab Fields.
Keempat hal penting ini bisa diilustrasikan melalui contoh struktur tabel berikut, di mana terdapat 6 (Enam) Table Lookup dan sebuah Table untuk mengimplementasikannya. Anda bisa menggunakan script di bawah ini untuk melatih pemahaman Anda bagaimana sebaiknya merancang struktur tabel yang terkait dengan kebutuhan Dynamic Selection List ini.
/*
Navicat MySQL Data Transfer
Source Server : MySQL localhost
Source Server Version : 50508
Source Host : 127.0.0.1:3306
Source Database : dynamicselection
Target Server Type : MYSQL
Target Server Version : 50508
File Encoding : 65001
Date: 2014-12-02 09:58:27
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for implementation
-- ----------------------------
DROP TABLE IF EXISTS `implementation`;
CREATE TABLE `implementation` (
`Table1_Code` char(3) NOT NULL,
`Table2_Code` char(3) NOT NULL,
`Table3_Code` char(3) NOT NULL,
`Table4_Code` char(3) NOT NULL,
`Table5_Code` char(3) NOT NULL,
`Table6_Code` char(3) NOT NULL,
`Description_Implementation` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Table1_Code`,`Table2_Code`,`Table3_Code`,`Table4_Code`,`Table5_Code`,`Table6_Code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of implementation
-- ----------------------------
INSERT INTO `implementation` VALUES ('001', '001', '001', '055', '001', '001', 'First Implementation');
INSERT INTO `implementation` VALUES ('001', '001', '001', '055', '001', '002', 'Second Implementation');
INSERT INTO `implementation` VALUES ('001', '001', '001', '055', '001', '003', 'Third Implementation');
-- ----------------------------
-- 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-004 < Table1-002');
INSERT INTO `table2` VALUES ('002', '005', 'Table2-005 < Table1-002');
INSERT INTO `table2` VALUES ('002', '006', 'Table2-006 < Table1-002');
INSERT INTO `table2` VALUES ('003', '007', 'Table2-007 < Table1-003');
INSERT INTO `table2` VALUES ('003', '008', 'Table2-008 < Table1-003');
INSERT INTO `table2` VALUES ('003', '009', 'Table2-009 < 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-004 < Table2-002 < Table1-001');
INSERT INTO `table3` VALUES ('001', '002', '005', 'Table3-005 < Table2-002 < Table1-001');
INSERT INTO `table3` VALUES ('001', '002', '006', 'Table3-006 < Table2-002 < Table1-001');
INSERT INTO `table3` VALUES ('001', '003', '007', 'Table3-007 < Table2-003 < Table1-001');
INSERT INTO `table3` VALUES ('001', '003', '008', 'Table3-008 < Table2-003 < Table1-001');
INSERT INTO `table3` VALUES ('001', '003', '009', 'Table3-009 < Table2-003 < Table1-001');
INSERT INTO `table3` VALUES ('002', '004', '010', 'Table3-010 < Table2-001 < Table1-002');
INSERT INTO `table3` VALUES ('002', '004', '011', 'Table3-011 < Table2-001 < Table1-002');
INSERT INTO `table3` VALUES ('002', '004', '012', 'Table3-012 < Table2-001 < Table1-002');
INSERT INTO `table3` VALUES ('002', '005', '013', 'Table3-013 < Table2-002 < Table1-002');
INSERT INTO `table3` VALUES ('002', '005', '014', 'Table3-014 < Table2-002 < Table1-002');
INSERT INTO `table3` VALUES ('002', '005', '015', 'Table3-015 < Table2-002 < Table1-002');
INSERT INTO `table3` VALUES ('002', '006', '016', 'Table3-016 < Table2-003 < Table1-002');
INSERT INTO `table3` VALUES ('002', '006', '017', 'Table3-017 < Table2-003 < Table1-002');
INSERT INTO `table3` VALUES ('002', '006', '018', 'Table3-018 < Table2-003 < Table1-002');
INSERT INTO `table3` VALUES ('003', '007', '019', 'Table3-018 < Table2-001 < Table1-003');
INSERT INTO `table3` VALUES ('003', '007', '020', 'Table3-020 < Table2-001 < Table1-003');
INSERT INTO `table3` VALUES ('003', '007', '021', 'Table3-021 < Table2-001 < Table1-003');
INSERT INTO `table3` VALUES ('003', '008', '022', 'Table3-022 < Table2-002 < Table1-003');
INSERT INTO `table3` VALUES ('003', '008', '023', 'Table3-023 < Table2-002 < Table1-003');
INSERT INTO `table3` VALUES ('003', '008', '024', 'Table3-024 < Table2-002 < Table1-003');
INSERT INTO `table3` VALUES ('003', '009', '025', 'Table3-025 < Table2-003 < Table1-003');
INSERT INTO `table3` VALUES ('003', '009', '026', 'Table3-026 < Table2-003 < Table1-003');
INSERT INTO `table3` VALUES ('003', '009', '027', 'Table3-027 < Table2-003 < Table1-003');
-- ----------------------------
-- Table structure for table4
-- ----------------------------
DROP TABLE IF EXISTS `table4`;
CREATE TABLE `table4` (
`Table1_Code` char(3) NOT NULL,
`Table2_Code` char(3) NOT NULL,
`Table3_Code` char(3) NOT NULL,
`Table4_Code` char(3) NOT NULL,
`Description` varchar(200) DEFAULT NULL,
PRIMARY KEY (`Table1_Code`,`Table2_Code`,`Table3_Code`,`Table4_Code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of table4
-- ----------------------------
INSERT INTO `table4` VALUES ('003', '007', '019', '001', 'Table4-001 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table4` VALUES ('003', '007', '019', '002', 'Table4-002 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table4` VALUES ('003', '007', '019', '003', 'Table4-003 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table4` VALUES ('003', '007', '020', '004', 'Table4-004 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table4` VALUES ('003', '007', '020', '005', 'Table4-005 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table4` VALUES ('003', '007', '020', '006', 'Table4-006 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table4` VALUES ('003', '007', '021', '007', 'Table4-007 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table4` VALUES ('003', '007', '021', '008', 'Table4-008 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table4` VALUES ('003', '007', '021', '009', 'Table4-009 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table4` VALUES ('003', '008', '022', '010', 'Table4-010 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table4` VALUES ('003', '008', '022', '011', 'Table4-011 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table4` VALUES ('003', '008', '022', '012', 'Table4-012 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table4` VALUES ('003', '008', '023', '013', 'Table4-013 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table4` VALUES ('003', '008', '023', '014', 'Table4-014 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table4` VALUES ('003', '008', '023', '015', 'Table4-015 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table4` VALUES ('003', '008', '024', '016', 'Table4-016 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table4` VALUES ('003', '008', '024', '017', 'Table4-017 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table4` VALUES ('003', '008', '024', '018', 'Table4-018 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table4` VALUES ('003', '009', '025', '019', 'Table4-019 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table4` VALUES ('003', '009', '025', '020', 'Table4-020 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table4` VALUES ('003', '009', '025', '021', 'Table4-021 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table4` VALUES ('003', '009', '026', '022', 'Table4-022 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table4` VALUES ('003', '009', '026', '023', 'Table4-023 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table4` VALUES ('003', '009', '026', '024', 'Table4-024 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table4` VALUES ('003', '009', '027', '025', 'Table4-025 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table4` VALUES ('003', '009', '027', '026', 'Table4-026 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table4` VALUES ('003', '009', '027', '027', 'Table4-027 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table4` VALUES ('002', '004', '010', '028', 'Table4-028 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table4` VALUES ('002', '004', '010', '029', 'Table4-029 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table4` VALUES ('002', '004', '010', '030', 'Table4-030 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table4` VALUES ('002', '004', '011', '031', 'Table4-031 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table4` VALUES ('002', '004', '011', '032', 'Table4-032 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table4` VALUES ('002', '004', '011', '033', 'Table4-033 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table4` VALUES ('002', '004', '012', '034', 'Table4-034 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table4` VALUES ('002', '004', '012', '035', 'Table4-035 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table4` VALUES ('002', '004', '012', '036', 'Table4-036 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table4` VALUES ('002', '005', '013', '037', 'Table4-037 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table4` VALUES ('002', '005', '013', '038', 'Table4-038 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table4` VALUES ('002', '005', '013', '039', 'Table4-039 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table4` VALUES ('002', '005', '014', '040', 'Table4-040 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table4` VALUES ('002', '005', '014', '041', 'Table4-041 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table4` VALUES ('002', '005', '014', '042', 'Table4-042 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table4` VALUES ('002', '005', '015', '043', 'Table4-043 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table4` VALUES ('002', '005', '015', '044', 'Table4-044 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table4` VALUES ('002', '005', '015', '045', 'Table4-045 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table4` VALUES ('002', '006', '016', '046', 'Table4-046 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table4` VALUES ('002', '006', '016', '047', 'Table4-047 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table4` VALUES ('002', '006', '016', '048', 'Table4-048 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table4` VALUES ('002', '006', '017', '049', 'Table4-049 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table4` VALUES ('002', '006', '017', '050', 'Table4-050 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table4` VALUES ('002', '006', '017', '051', 'Table4-051 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table4` VALUES ('002', '006', '018', '052', 'Table4-052 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table4` VALUES ('002', '006', '018', '053', 'Table4-053 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table4` VALUES ('002', '006', '018', '054', 'Table4-054 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table4` VALUES ('001', '001', '001', '055', 'Table4-055 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table4` VALUES ('001', '001', '001', '056', 'Table4-056 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table4` VALUES ('001', '001', '001', '057', 'Table4-057 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table4` VALUES ('001', '001', '002', '058', 'Table4-058 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table4` VALUES ('001', '001', '002', '059', 'Table4-059 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table4` VALUES ('001', '001', '002', '060', 'Table4-060 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table4` VALUES ('001', '001', '003', '061', 'Table4-061 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table4` VALUES ('001', '001', '003', '062', 'Table4-062 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table4` VALUES ('001', '001', '003', '063', 'Table4-063 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table4` VALUES ('001', '002', '004', '064', 'Table4-064 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table4` VALUES ('001', '002', '004', '065', 'Table4-065 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table4` VALUES ('001', '002', '004', '066', 'Table4-066 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table4` VALUES ('001', '002', '005', '067', 'Table4-067 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table4` VALUES ('001', '002', '005', '068', 'Table4-068 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table4` VALUES ('001', '002', '005', '069', 'Table4-069 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table4` VALUES ('001', '002', '006', '070', 'Table4-070 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table4` VALUES ('001', '002', '006', '071', 'Table4-071 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table4` VALUES ('001', '002', '006', '072', 'Table4-072 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table4` VALUES ('001', '003', '007', '073', 'Table4-073 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table4` VALUES ('001', '003', '007', '074', 'Table4-074 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table4` VALUES ('001', '003', '007', '075', 'Table4-075 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table4` VALUES ('001', '003', '008', '076', 'Table4-076 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table4` VALUES ('001', '003', '008', '077', 'Table4-077 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table4` VALUES ('001', '003', '008', '078', 'Table4-078 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table4` VALUES ('001', '003', '009', '079', 'Table4-079 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table4` VALUES ('001', '003', '009', '080', 'Table4-080 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table4` VALUES ('001', '003', '009', '081', 'Table4-081 < Table3-003 < Table2-003 < Table1-001');
-- ----------------------------
-- Table structure for table5
-- ----------------------------
DROP TABLE IF EXISTS `table5`;
CREATE TABLE `table5` (
`Table1_Code` char(3) NOT NULL,
`Table2_Code` char(3) NOT NULL,
`Table3_Code` char(3) NOT NULL,
`Table4_Code` char(3) NOT NULL,
`Table5_Code` char(3) NOT NULL,
`Description` varchar(200) DEFAULT NULL,
PRIMARY KEY (`Table1_Code`,`Table2_Code`,`Table3_Code`,`Table4_Code`,`Table5_Code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of table5
-- ----------------------------
INSERT INTO `table5` VALUES ('001', '001', '001', '055', '001', 'Table5-001 < Table4-001 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '001', '055', '002', 'Table5-002 < Table4-001 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '001', '055', '003', 'Table5-003 < Table4-001 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '001', '056', '004', 'Table5-004 < Table4-002 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '001', '056', '005', 'Table5-005 < Table4-002 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '001', '056', '006', 'Table5-006 < Table4-002 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '001', '057', '007', 'Table5-007 < Table4-003 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '001', '057', '008', 'Table5-008 < Table4-003 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '001', '057', '009', 'Table5-009 < Table4-003 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '002', '058', '010', 'Table5-010 < Table4-001 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '002', '058', '011', 'Table5-011 < Table4-001 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '002', '058', '012', 'Table5-012 < Table4-001 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '002', '059', '013', 'Table5-013 < Table4-002 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '002', '059', '014', 'Table5-014 < Table4-002 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '002', '059', '015', 'Table5-015 < Table4-002 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '002', '060', '016', 'Table5-016 < Table4-003 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '002', '060', '017', 'Table5-017 < Table4-003 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '002', '060', '018', 'Table5-018 < Table4-003 < Table3-002 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '003', '061', '019', 'Table5-019 < Table4-001 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '003', '061', '020', 'Table5-020 < Table4-001 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '003', '061', '021', 'Table5-021 < Table4-001 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '003', '062', '022', 'Table5-022 < Table4-002 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '003', '062', '023', 'Table5-023 < Table4-002 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '003', '062', '024', 'Table5-024 < Table4-002 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '003', '063', '025', 'Table5-025 < Table4-003 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '003', '063', '026', 'Table5-026 < Table4-003 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '001', '003', '063', '027', 'Table5-027 < Table4-003 < Table3-003 < Table2-001 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '004', '064', '028', 'Table5-028 < Table4-001 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '004', '064', '029', 'Table5-029 < Table4-001 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '004', '064', '030', 'Table5-030 < Table4-001 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '004', '065', '031', 'Table5-031 < Table4-002 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '004', '065', '032', 'Table5-032 < Table4-002 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '004', '065', '033', 'Table5-033 < Table4-002 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '004', '066', '034', 'Table5-034 < Table4-003 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '004', '066', '035', 'Table5-035 < Table4-003 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '004', '066', '036', 'Table5-036 < Table4-003 < Table3-001 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '005', '067', '037', 'Table5-037 < Table4-001 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '005', '067', '038', 'Table5-038 < Table4-001 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '005', '067', '039', 'Table5-039 < Table4-001 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '005', '068', '040', 'Table5-040 < Table4-002 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '005', '068', '041', 'Table5-041 < Table4-002 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '005', '068', '042', 'Table5-042 < Table4-002 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '005', '069', '043', 'Table5-043 < Table4-003 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '005', '069', '044', 'Table5-044 < Table4-003 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '005', '069', '045', 'Table5-045 < Table4-003 < Table3-002 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '006', '070', '046', 'Table5-046 < Table4-001 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '006', '070', '047', 'Table5-047 < Table4-001 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '006', '070', '048', 'Table5-048 < Table4-001 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '006', '071', '049', 'Table5-049 < Table4-002 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '006', '071', '050', 'Table5-050 < Table4-002 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '006', '071', '051', 'Table5-051 < Table4-002 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '006', '072', '052', 'Table5-052 < Table4-003 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '006', '072', '053', 'Table5-053 < Table4-003 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '002', '006', '072', '054', 'Table5-054 < Table4-003 < Table3-003 < Table2-002 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '007', '073', '055', 'Table5-055 < Table4-001 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '007', '073', '056', 'Table5-056 < Table4-001 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '007', '073', '057', 'Table5-057 < Table4-001 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '007', '074', '058', 'Table5-058 < Table4-002 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '007', '074', '059', 'Table5-059 < Table4-002 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '007', '074', '060', 'Table5-060 < Table4-002 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '007', '075', '061', 'Table5-061 < Table4-003 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '007', '075', '062', 'Table5-062 < Table4-003 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '007', '075', '063', 'Table5-063 < Table4-003 < Table3-001 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '008', '076', '064', 'Table5-064 < Table4-001 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '008', '076', '065', 'Table5-065 < Table4-001 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '008', '076', '066', 'Table5-066 < Table4-001 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '008', '077', '067', 'Table5-067 < Table4-002 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '008', '077', '068', 'Table5-068 < Table4-002 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '008', '077', '069', 'Table5-069 < Table4-002 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '008', '078', '070', 'Table5-070 < Table4-003 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '008', '078', '071', 'Table5-071 < Table4-003 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '008', '078', '072', 'Table5-072 < Table4-003 < Table3-002 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '009', '079', '073', 'Table5-073 < Table4-001 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '009', '079', '074', 'Table5-074 < Table4-001 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '009', '079', '075', 'Table5-075 < Table4-001 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '009', '080', '076', 'Table5-076 < Table4-002 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '009', '080', '077', 'Table5-077 < Table4-002 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '009', '080', '078', 'Table5-078 < Table4-002 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '009', '081', '079', 'Table5-079 < Table4-003 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '009', '081', '080', 'Table5-080 < Table4-003 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('001', '003', '009', '081', '081', 'Table5-081 < Table4-003 < Table3-003 < Table2-003 < Table1-001');
INSERT INTO `table5` VALUES ('002', '004', '010', '028', '082', 'Table5-082 < Table4-001 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '010', '028', '083', 'Table5-083 < Table4-001 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '010', '028', '084', 'Table5-084 < Table4-001 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '010', '029', '085', 'Table5-085 < Table4-002 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '010', '029', '086', 'Table5-086 < Table4-002 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '010', '029', '087', 'Table5-087 < Table4-002 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '010', '030', '088', 'Table5-088 < Table4-003 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '010', '030', '089', 'Table5-089 < Table4-003 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '010', '030', '090', 'Table5-090 < Table4-003 < Table3-001 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '011', '031', '091', 'Table5-091 < Table4-001 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '011', '031', '092', 'Table5-092 < Table4-001 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '011', '031', '093', 'Table5-093 < Table4-001 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '011', '032', '094', 'Table5-094 < Table4-002 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '011', '032', '095', 'Table5-095 < Table4-002 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '011', '032', '096', 'Table5-096 < Table4-002 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '011', '033', '097', 'Table5-097 < Table4-003 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '011', '033', '098', 'Table5-098 < Table4-003 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '011', '033', '099', 'Table5-099 < Table4-003 < Table3-002 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '012', '034', '100', 'Table5-100 < Table4-001 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '012', '034', '101', 'Table5-101 < Table4-001 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '012', '034', '102', 'Table5-102 < Table4-001 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '012', '035', '103', 'Table5-103 < Table4-002 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '012', '035', '104', 'Table5-104 < Table4-002 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '012', '035', '105', 'Table5-105 < Table4-002 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '012', '036', '106', 'Table5-106 < Table4-003 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '012', '036', '107', 'Table5-107 < Table4-003 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '004', '012', '036', '108', 'Table5-108 < Table4-003 < Table3-003 < Table2-001 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '013', '037', '109', 'Table5-109 < Table4-001 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '013', '037', '110', 'Table5-110 < Table4-001 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '013', '037', '111', 'Table5-111 < Table4-001 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '013', '038', '112', 'Table5-112 < Table4-002 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '013', '038', '113', 'Table5-113 < Table4-002 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '013', '038', '114', 'Table5-114 < Table4-002 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '013', '039', '115', 'Table5-115 < Table4-003 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '013', '039', '116', 'Table5-116 < Table4-003 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '013', '039', '117', 'Table5-117 < Table4-003 < Table3-001 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '014', '040', '118', 'Table5-118 < Table4-001 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '014', '040', '119', 'Table5-119 < Table4-001 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '014', '040', '120', 'Table5-120 < Table4-001 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '014', '041', '121', 'Table5-121 < Table4-002 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '014', '041', '122', 'Table5-122 < Table4-002 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '014', '041', '123', 'Table5-123 < Table4-002 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '014', '042', '124', 'Table5-124 < Table4-003 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '014', '042', '125', 'Table5-125 < Table4-003 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '014', '042', '126', 'Table5-126 < Table4-003 < Table3-002 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '015', '043', '127', 'Table5-127 < Table4-001 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '015', '043', '128', 'Table5-128 < Table4-001 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '015', '043', '129', 'Table5-129 < Table4-001 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '015', '044', '130', 'Table5-130 < Table4-002 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '015', '044', '131', 'Table5-131 < Table4-002 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '015', '044', '132', 'Table5-132 < Table4-002 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '015', '045', '133', 'Table5-133 < Table4-003 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '015', '045', '134', 'Table5-134 < Table4-003 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '005', '015', '045', '135', 'Table5-135 < Table4-003 < Table3-003 < Table2-002 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '016', '046', '136', 'Table5-136 < Table4-001 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '016', '046', '137', 'Table5-137 < Table4-001 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '016', '046', '138', 'Table5-138 < Table4-001 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '016', '047', '139', 'Table5-139 < Table4-002 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '016', '047', '140', 'Table5-140 < Table4-002 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '016', '047', '141', 'Table5-141 < Table4-002 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '016', '048', '142', 'Table5-142 < Table4-003 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '016', '048', '143', 'Table5-143 < Table4-003 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '016', '048', '144', 'Table5-144 < Table4-003 < Table3-001 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '017', '049', '145', 'Table5-145 < Table4-001 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '017', '049', '146', 'Table5-146 < Table4-001 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '017', '049', '147', 'Table5-147 < Table4-001 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '017', '050', '148', 'Table5-148 < Table4-002 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '017', '050', '149', 'Table5-149 < Table4-002 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '017', '050', '150', 'Table5-150 < Table4-002 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '017', '051', '151', 'Table5-151 < Table4-003 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '017', '051', '152', 'Table5-152 < Table4-003 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '017', '051', '153', 'Table5-153 < Table4-003 < Table3-002 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '018', '052', '154', 'Table5-154 < Table4-001 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '018', '052', '155', 'Table5-155 < Table4-001 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '018', '052', '156', 'Table5-156 < Table4-001 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '018', '053', '157', 'Table5-157 < Table4-002 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '018', '053', '158', 'Table5-158 < Table4-002 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '018', '053', '159', 'Table5-159 < Table4-002 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '018', '054', '160', 'Table5-160 < Table4-003 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '018', '054', '161', 'Table5-161 < Table4-003 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('002', '006', '018', '054', '162', 'Table5-162 < Table4-003 < Table3-003 < Table2-003 < Table1-002');
INSERT INTO `table5` VALUES ('003', '007', '019', '001', '163', 'Table5-163 < Table4-001 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '019', '001', '164', 'Table5-164 < Table4-001 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '019', '001', '165', 'Table5-165 < Table4-001 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '019', '002', '166', 'Table5-166 < Table4-002 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '019', '002', '167', 'Table5-167 < Table4-002 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '019', '002', '168', 'Table5-168 < Table4-002 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '019', '003', '169', 'Table5-169 < Table4-003 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '019', '003', '170', 'Table5-170 < Table4-003 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '019', '003', '171', 'Table5-171 < Table4-003 < Table3-001 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '020', '004', '172', 'Table5-172 < Table4-001 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '020', '004', '173', 'Table5-173 < Table4-001 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '020', '004', '174', 'Table5-174 < Table4-001 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '020', '005', '175', 'Table5-175 < Table4-002 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '020', '005', '176', 'Table5-176 < Table4-002 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '020', '005', '177', 'Table5-177 < Table4-002 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '020', '006', '178', 'Table5-178 < Table4-003 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '020', '006', '179', 'Table5-179 < Table4-003 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '020', '006', '180', 'Table5-180 < Table4-003 < Table3-002 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '021', '007', '181', 'Table5-181 < Table4-001 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '021', '007', '182', 'Table5-182 < Table4-001 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '021', '007', '183', 'Table5-183 < Table4-001 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '021', '008', '184', 'Table5-184 < Table4-002 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '021', '008', '185', 'Table5-185 < Table4-002 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '021', '008', '186', 'Table5-186 < Table4-002 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '021', '009', '187', 'Table5-187 < Table4-003 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '021', '009', '188', 'Table5-188 < Table4-003 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '007', '021', '009', '189', 'Table5-189 < Table4-003 < Table3-003 < Table2-001 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '022', '010', '190', 'Table5-190 < Table4-001 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '022', '010', '191', 'Table5-191 < Table4-001 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '022', '010', '192', 'Table5-192 < Table4-001 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '022', '011', '193', 'Table5-193 < Table4-002 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '022', '011', '194', 'Table5-194 < Table4-002 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '022', '011', '195', 'Table5-195 < Table4-002 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '022', '012', '196', 'Table5-196 < Table4-003 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '022', '012', '197', 'Table5-197 < Table4-003 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '022', '012', '198', 'Table5-198 < Table4-003 < Table3-001 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '023', '013', '199', 'Table5-199 < Table4-001 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '023', '013', '200', 'Table5-200 < Table4-001 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '023', '013', '201', 'Table5-201 < Table4-001 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '023', '014', '202', 'Table5-202 < Table4-002 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '023', '014', '203', 'Table5-203 < Table4-002 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '023', '014', '204', 'Table5-204 < Table4-002 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '023', '015', '205', 'Table5-205 < Table4-003 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '023', '015', '206', 'Table5-206 < Table4-003 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '023', '015', '207', 'Table5-207 < Table4-003 < Table3-002 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '024', '016', '208', 'Table5-208 < Table4-001 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '024', '016', '209', 'Table5-209 < Table4-001 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '024', '016', '210', 'Table5-210 < Table4-001 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '024', '017', '211', 'Table5-211 < Table4-002 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '024', '017', '212', 'Table5-212 < Table4-002 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '024', '017', '213', 'Table5-213 < Table4-002 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '024', '018', '214', 'Table5-214 < Table4-003 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '024', '018', '215', 'Table5-215 < Table4-003 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '008', '024', '018', '216', 'Table5-216 < Table4-003 < Table3-003 < Table2-002 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '025', '019', '217', 'Table5-217 < Table4-001 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '025', '019', '218', 'Table5-218 < Table4-001 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '025', '019', '219', 'Table5-219 < Table4-001 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '025', '020', '220', 'Table5-220 < Table4-002 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '025', '020', '221', 'Table5-221 < Table4-002 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '025', '020', '222', 'Table5-222 < Table4-002 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '025', '021', '223', 'Table5-223 < Table4-003 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '025', '021', '224', 'Table5-224 < Table4-003 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '025', '021', '225', 'Table5-225 < Table4-003 < Table3-001 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '026', '022', '226', 'Table5-226 < Table4-001 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '026', '022', '227', 'Table5-227 < Table4-001 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '026', '022', '228', 'Table5-228 < Table4-001 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '026', '023', '229', 'Table5-229 < Table4-002 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '026', '023', '230', 'Table5-230 < Table4-002 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '026', '023', '231', 'Table5-231 < Table4-002 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '026', '024', '232', 'Table5-232 < Table4-003 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '026', '024', '233', 'Table5-233 < Table4-003 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '026', '024', '234', 'Table5-234 < Table4-003 < Table3-002 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '027', '025', '235', 'Table5-235 < Table4-001 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '027', '025', '236', 'Table5-236 < Table4-001 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '027', '025', '237', 'Table5-237 < Table4-001 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '027', '026', '238', 'Table5-238 < Table4-002 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '027', '026', '239', 'Table5-239 < Table4-002 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '027', '026', '240', 'Table5-240 < Table4-002 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '027', '027', '241', 'Table5-241 < Table4-003 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '027', '027', '242', 'Table5-242 < Table4-003 < Table3-003 < Table2-003 < Table1-003');
INSERT INTO `table5` VALUES ('003', '009', '027', '027', '243', 'Table5-243 < Table4-003 < Table3-003 < Table2-003 < Table1-003');
-- ----------------------------
-- Table structure for table6
-- ----------------------------
DROP TABLE IF EXISTS `table6`;
CREATE TABLE `table6` (
`Table1_Code` char(3) NOT NULL,
`Table2_Code` char(3) NOT NULL,
`Table3_Code` char(3) NOT NULL,
`Table4_Code` char(3) NOT NULL,
`Table5_Code` char(3) NOT NULL,
`Table6_Code` char(3) NOT NULL,
`Description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`Table1_Code`,`Table2_Code`,`Table3_Code`,`Table4_Code`,`Table5_Code`,`Table6_Code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of table6
-- ----------------------------
INSERT INTO `table6` VALUES ('001', '001', '001', '055', '001', '001', 'Table6-001 < Table5-001 < Table4-001 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table6` VALUES ('001', '001', '001', '055', '001', '002', 'Table6-002 < Table5-001 < Table4-001 < Table3-001 < Table2-001 < Table1-001');
INSERT INTO `table6` VALUES ('001', '001', '001', '055', '001', '003', 'Table6-003 < Table5-001 < Table4-001 < Table3-001 < Table2-001 < Table1-001');
Om bisa gak PHPMaker yang diinput memasukkan kode yg dibutuhkan saja dalam table implementasi jadi kode parent tidak usah dimasukkan dalam table implementasi, namun masih menggunakan dinamyc selection dalam search atau ketika input ? karena menurut saya yang dimasukkan dalam table implementasi cukup kode yg ada pada table6.
Nah, harus diakui bahwa itu keterbatasan di PHPMaker untuk sekarang ini. Semua field parent terkait harus disertakan di dalam tabel supaya bisa mengimplementasikan Dynamic Selection List.
Dulu sebenarnya saya sudah pernah mengusulkan ke author PHPMaker supaya menambahkan fitur Custom Fields untuk mengatasi isu tadi. Sayangnya, sampai v11 ini belum dipenuhi. Mudah-mudahan di v12, atau Anda bisa ikut mem-vote dengan mereply topik ini:
http://www.hkvforums.com/viewtopic.php?f=5&t=22632
Post terakhir di topik tersebut oleh mobhar, itu dikirim oleh saya. 😉
Dear Bang Masino
Untuk Type master detail, koq tidak berhasil ya..
jadi skenario nya saya mau memfilter list barang saat lookup di table detail, berdasarkan kategori yang sudah dipilih di field kategori table master.
tapi setelah saya setup, patent table, parent field & Filter field kemudian di generate
lookup data nya tidak berhasil alisa blank data.
Periksa ulang lagi relasi antara tabel master dan tabel detailnya. Kalau relasi datanya sudah tepat, seharusnya tidak ada masalah.