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

[padma]

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 

[timl]

@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/