I think the Server Validation is working correctly.
When Insert is pressed the page does not change.
I cannot seem to get "Validation Show If" working.
I have text in red "Enter a Manufacturer", I highlight this, select Validation Show If but that does not appear in the drop down box . I have uploaded an image of this and another zip with the file.