Modified the add location function and add a condition for setting the fields into empty("") and 0 if it is NULL, this way the data will be saved in the blue yonder, modified as well the updating of location. Tested the modified add location function, tried to add a new location when the new location is added in MySQL, the added location will be added as well in the blue yonder. As per testing, the location added in the web application is added in the blue yonder, checked if the data added is correct, as per checking and comparing, it is correct. Advised Edgar that a location is now added in the blue yonder for his checking.