hi every one i have a customer and booking data sets on my form. customer id is a foreign key in booking table .but when i click delete button. it gives me an error
The DELETE statement conflicted with the REFERENCE constraint "FK_Booking_Customer". The conflict occurred in database "photoshoot", table "dbo.Booking", column 'Cust_id'.
The statement has been terminated.
plz give me any idea how to solve this problem. its a one to many relation between customer and booking. one customer can make many bookings each booking will belong to only 1 customer