insert into Management.Events(EventName, StartDate, EndDate, Location, NoOfPeople, StaffRequired, EventTypeID, CustomerID, EmployeeID)
Values('fashion show', '2021-12-25', '2021-12-25', 'el cercado', '50', '2', '8672', '123451', '4'),
('exhibitions', '2022-01-25', '2022-01-27', 'el cercado', '45', '3', '8673', '123452', '2'),
('charity show', '2022-02-25', '2022-02/27', 'el cercado', '40', '5', '8674', '123453', '6')
When i try to execute this query it shows me this
Msg 547, Level 16, State 0, Line 38
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Events__EventTyp__20C1E124". The conflict occurred in database "ShowmanHouse", table "Events.EventTypes", column 'EventTypeID'.
The statement has been terminated.
What I have tried:
What i have tried to do is to check the insert statement again and try to see if i can find the problem