Member Avatar for dilse4sk

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

  • 2 Contributors
  • 1 Reply
  • 103 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

Can we see the full information? Names and structures of the tables as well as the exact query you are running to do the delete?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.