Action in database MYSQL

[Msant77s]

Hello good mornig for everyone.

I contact you to ask you a question about an application that I am working on for the management of tools in a warehouse.

I'm having problems configuring my database in MYSQL, I used to use this app with Google sheet before, but due to synchronization time problems I'm wanting to migrate to a database with MYSQL.

The problem I'm having is between two tables:

Table 1: "Prestamosmultiples" whose function is to collect through a form the tools that a company worker borrows from the deposit. In this table the warehouse manager takes the order of the tools that the worker wants to withdraw through an enumlist column, where he can select multiple tools.

Then, when saving the form, a series of actions are unleashed that I use to create a unique record for each selected tool in another table, table2 "Prestamos".

Actions:



This operation in the application with Google sheet works correctly, but in the current application with MYSQL it does not work, it is only sending a new row in the table. We provide the first tool code and it does not create the following ones, I am sure that this is the case due to a problem in the counter action "Action 2" and the way I have configured the database in MYSQL, but I can't find what the error could be.
I leave the configuration of my tables in MYSQL:
Table 1: "Prestamosmultiples"

Table2: "Prestamos"

I hope you can help me, I already tried to migrate this database to an internal database in Apsheet Database but it was impossible, many functions are not compatible with my application and it was very difficult for me to migrate this database.
Thank you very much for your time.