Updating multiple records with this query has not been enabled

Hi, I've made a query that updates a table once someone presses a save changes button after making changes to elements in the table connected to an SQL database. However currently when this query runs I am met with the error in the title - "Updating multiple records with this query has not been enabled" - I can't find where I am supposed to be able to enable this.

If anyone could point me in the direction to do this I would be extremely grateful

Welcome to the forum! Can you post a screenshot of the query? Did you save it? Or only preview it?

Thank you. I saved it as well as previewing it, but each time it gives me the error at the bottom

I've realised what I have done. I changed the filter from email to ID and it worked, as by filtering by email I was trying to edit multiple rows at once.

1 Like