Dynamic List loading not working in View

PHPMaker General Discussion (PHPMaker)
1

I have four tables

vehicle (v_id, make, model, v_reg)
customer (c_id,c_name, c_address)
make(mk_id, mk_title)
model(md_id, mk_id, md_title)in vehicle table advanced search i used dynamic list loading by linking al tables (hope no need to explain), when select mk_title in vehicle search then all md_title related to that make loads in select list below. It is OK.

now i have created a View v_report (make, model, v_reg, c_name) of vehicle and customer table but in advance search of v_report both lists of Make and Models loads and dynamic loading (by selecting make and loads its model) not working means no link of make and model is working here.Please guide why in View dynamic list loading not working but same is working in vehicle table perfectly. What steps should i take to achieve it in View

2

You should post your complete tables schema (CREATE TABLE …), not just mentioned the field name, so others could try to help straightforward.

3

You should enable Debug and check errors.

4

Sir, here are the four tables

`customer`  (
  `customer_id` int NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `customer_type` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `customer_trn` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `customer_license` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `customer_address` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `region_id` int NULL DEFAULT NULL,
  `customer_postal` int NULL DEFAULT NULL,
  `customer_mobile1` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `customer_mobile2` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `customer_email` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `customer_other` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `customer_status` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `customer_date` date NOT NULL,
  PRIMARY KEY (`customer_id`)



`vehicle`  (
  `vehicle_id` int NOT NULL AUTO_INCREMENT,
  `make` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `model` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `vehicle_year` int NOT NULL,
  `customer_id` int NOT NULL,
  `vehicle_type` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `vehicle_registration_no` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `vehicle_engine_no` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `vehicle_chassis_no` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `vehicle_origin` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `vehicle_cylinder` int NULL DEFAULT NULL,
  `vehicle_transmission` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `vehicle_traffic_symbol` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `vehicle_color` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `vehicle_des` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `vehicle_image` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `vehicle_status` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `vehicle_date` date NOT NULL,
  PRIMARY KEY (`vehicle_id`)


`make`  (
  `make` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`make`)


model`  (
  `make` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `model` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`model`)

in vehicle table search ‘model’ list only loaded when we select ‘make’ from the list and working fine but in below View search all models are preloaded in the list without 'make selection’SELECT work.work_id AS work_id, work.work_io AS work_io, work.work_type AS work_type, work.work_date AS work_date, work.work_date_completion AS work_date_completion, customer.customer_name AS customer_name, customer.customer_type AS customer_type, customer.customer_mobile1 AS customer_mobile1, vehicle.vehicle_registration_no AS vehicle_registration_no, vehicle.make AS make, vehicle.model AS model FROM (work JOIN customer ON customer.customer_id = work.customer_id) JOIN vehicle ON vehicle.vehicle_id = work.vehicle_id AND customer.customer_id = vehicle.customer_idi tried selecting list of make and models from vehicle table and even directly from make and model tables but result is same. Also used child lookup option in make table for models as done in vehicle table but again result is same
Please advise