Masino Sinaga

Web Development and PHPMaker

Anda di sini: Beranda / PHPMaker / Hal-hal Penting Seputar Dynamic Selection List di Aplikasi Web dari PHPMaker
Dua Cara Menerapkan Dynamic Selection List di Aplikasi Web dari PHPMaker
Alasan Paling Kuat Mengapa Anda Harus Menggunakan PHPMaker Mulai Sekarang

Hal-hal Penting Seputar Dynamic Selection List di Aplikasi Web dari PHPMaker

Kam, 4 Desember 2014 oleh Masino Sinaga 4 Komentar

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');

Ditempatkan di bawah: PHPMaker Ditag dengan:Dynamic Selection List, Lookup Field, PHPMaker Indonesia, Tutorial PHPMaker

Masino Sinaga

Web Developer pengguna PHPMaker untuk membangun Aplikasi Web sejak tahun 2004. Sampai sekarang masih aktif dan rajin membagikan pengalamannya menggunakan PHPMaker melalui situs masinosinaga.com, ilovephpmaker.com, dan phpmakerprojects.com.

Dua Cara Menerapkan Dynamic Selection List di Aplikasi Web dari PHPMaker
Alasan Paling Kuat Mengapa Anda Harus Menggunakan PHPMaker Mulai Sekarang

Komentar

  1. Cak Sobri mengatakan

    Sen, 22 Desember 2014 pada 10:58 am

    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.

    Balas
    • Masino Sinaga mengatakan

      Sen, 22 Desember 2014 pada 11:15 am

      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. 😉

      Balas
  2. rudy budiana mengatakan

    Sel, 25 April 2017 pada 3:20 pm

    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.

    Balas
    • Masino Sinaga mengatakan

      Rab, 26 April 2017 pada 8:15 am

      Periksa ulang lagi relasi antara tabel master dan tabel detailnya. Kalau relasi datanya sudah tepat, seharusnya tidak ada masalah.

      Balas

Tinggalkan Balasan Batalkan balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

Situs ini menggunakan Akismet untuk mengurangi spam. Pelajari bagaimana data komentar Anda diproses

Pos-pos Terbaru

  • Masino Extensions for PHPMaker 2025 Now Changed!
  • Begini Mudahnya Mengurangi Lebar Combobox pada PHPMaker 2025
  • Mudahnya Mengubah Nilai Delay Auto Hide Success Message di PHPMaker 2025
  • Mudahnya Berpindah Layout dari Table ke Cards di Halaman List lewat PHPMaker 2025
  • Jangan Lupa Pakai AdjustSql Saat Insert atau Update Data Lewat ExecuteStatement

Menu

  • Siapa Saya?
  • Web Development
  • PHPMaker
  • Umum
  • Syarat dan Ketentuan
  • Sitemap (Peta Situs)
  • Komentar

Komentar Terbaru

  • Masino Sinaga pada Cara Mengetahui Detail Error di Aplikasi Web yang Dihasilkan oleh PHPMaker 2021
  • Dendi pada Cara Mengetahui Detail Error di Aplikasi Web yang Dihasilkan oleh PHPMaker 2021
  • Charly pada PHPMaker: PHP Code Generator + PHP Framework
  • Masino Sinaga pada PHPMaker: PHP Code Generator + PHP Framework
  • Masino Sinaga pada PHPMaker: PHP Code Generator + PHP Framework

Situs Terkait

  1. I Love PHPMaker
  2. Situs Resmi PHPMaker
  3. Forum Diskusi PHPMaker
  4. PHPMaker di IlmuKomputer.com
  5. PHPMaker Projects
  6. PHPMaker Learning

Baru di PHPMaker?

Baca ini terlebih dulu ...

  1. Ayo Menjadi Web Developer yang Cerdas!
  2. PHPMaker: PHP Code Generator + PHP Framework
  3. Pertanyaan-Pertanyaan yang Paling Sering Diajukan Seputar PHPMaker
  4. Tips buat Anda Pemula yang Baru Mengenal dan Menggunakan PHPMaker
  5. Bacalah Help, Bacalah Help, dan Bacalah Help di PHPMaker!

(c) Masino Sinaga 2009 - 2025 | WordPress | Catat masuk | Kembali ke atas