cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
padma
Helper I
Helper I

UPDATE statement conflicted with REFERENCE constraint (foreign key) on submiting the form

i get the error UPDATE statement conflicted with  REFERENCE constraint (foreign key) on submitting the form

there are two tables having primary -foreign key and using sql database,on updating parent table using lookup child table i get the error.

on select of submitform is SubmitForm('EditForm'),

how to resolve the error in power apps 

1 REPLY 1
timl
Super User
Super User

@padma 

>> updating parent table using lookup child table i get the error

I'm not completely sure what you're trying to do here. It sounds as though you're trying to update the primary key value on the parent table. If there are related child records, this would result in this error.

If this is the case, one way to resolve this would be to "cascade update" the child records. The "ON UPDATE CASCADE" section in this article describes this in more detail.

https://www.sqlservertutorial.net/sql-server-basics/sql-server-foreign-key/

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,185)