It works here with the foreign key declaration, there are 852 other tables that have not been mentioned or shown. The cons no is a foreign key in most of them.
Just out of interest how come the FPieces were created on the client side without a constructor but not on the server side?