Hi! I have a site page created from a record list (invoices)
When I click in one of the Invoices Id, I access to a summary view (interface), in which I created not only additional information of the record "invoices", but also a read-only grid from another record (Invoice Lines).
My problem here is that, if I try to eliminate the record (related record action) from this interface, it does not occur anything and the following error appears
I suppose it is caused because of the read-only grid generated in the interface (if I add no editable grid, it works fine). How can I solve this and being able to delete the invoices with the read-only grid inside?
Discussion posts and replies are publicly visible
That error message has nothing to do with any UI. It is the database trying to convince you that there is a foreign key constraint being violated.
I suppose the error occurs in the process model "Delete Invoice". Anyway, the fact is that the process is failing so I cannot delete my invoice rows directly
How can I afford this?
I cannot really help you with that. You need to analyse the tables, foreign keys and constraints in the cloud database.
In your Delete Invoice process model, you might have to first delete the referenced records then delete the Invoice record.