Second try to attach project
2 2022-09-19 16:02:16
Re: Multiple Records Being Updated (5 replies, posted in SQL queries)
I have attached it. I just tried to reproduce the problem and was unable to do so. But since this is my first project if you don't mind take a look and let me know if what I'm doing looks correct. The project is far from complete so I'd rather be sure I'm on the right track early. Thank you.
Got this message when I submitted the reply:
Warning! The following errors must be corrected before your message can be posted:
The selected file was too large to upload. The server didn't allow the upload.
File is 2.6 MB. The database is pretty large - I'll delete some of the records from the file I send and try again.
3 2022-09-19 15:14:20
Topic: Multiple Records Being Updated (5 replies, posted in SQL queries)
HI. New user here so I'm thinking I probably misconfigured something.
I have a table grid that displays all records - it's a long listing of words. When I select one row and then click on the edit button (show record action), a form opens that displays the one record. I have ranking values assigned to the words. When I change the ranking and click the save button (save record action), the edit form closes, and in the grid, I can see the new ranking score but also several other records around the selected record also have their ranks updated to the new value.
Is there any way I can view the update record query that is triggered when I click the save button? That might help in troubleshooting what is happening.
Thank you.