continued the modification in the application for adding the condition in the application to catch the duplicate value if the brand is a different brand, tested the application to check if the error will be fixed, as per checking, the error still encountered, checked why the data still not fixed, as per checking, the data that is duplicating has the same brand thus it did not fix by the added condition, the only difference on the data is the cost, modified the query and set the cost as zero, this is not used in the application as well as in converting of data, group the data thus it will not return any duplicate. Removed the added condition then test the application again, as per testing, no error has been encountered. Modified the query of updating Masterfile per brand, and did the same process, set the cost into zero and group the data, tested the updating, and no error encountered as well.