1. if [Data].[Finance_Project_Number] = Null/Blank
· Set [Processing_Result] = 2
· set [Processing_Result_Text] = “No Project Number”
2. if [Data].[Finance_Project_Region] = Null/Blank
· set [Processing_Result_Text] = “No Region”
Also, on point no 2, how can I check for valid entries? Something like “one of”: Gauteng, Free State, Limpopo etc. If it is “one of” then it passes, otherwise;
· set [Processing_Result_Text] = “Incorrect Region Entered”
3. Cross reference the customer number with another table.column: [Data].[Customer_Number] exists in [CustomerMaster].[Customer_Code]
if not:
· set [Processing_Result_Text] = “Customer Number does not Exist”