What error it is giving. You have given data for only MatNat table, so I can't replicate it.

But Check the value of Hotel, Nation & Match Table to see if the value exists in these tables what you are trying to insert.