Connection on form/ select NON RUN WHY? SC VER.9.10

I have a form that operates under a connection, inside it I have a select based on a table that resides on another db and therefore another connection. in the definition of the select obviously I populate the connection field.

IT DOESN’T WORK

If I run the app with the primary connection it works, but if I use the secondary connection it DOESN’T WORK i.e. it doesn’t give a damn about the connection field and in fact it shows me the empty select.

now either I’m the one who didn’t understand anything or the thing is becoming seriously ridiculous.
Connections i.e. the use of distributed db is fundamental in various sectors.
Am I or am I managing things wrong?
2024-09-27 11_31_15-ScriptCase - Sviluppo - admin – Mozilla Firefox

I had issue with similar with that select before, I ended up just using one field:

select login from sys_users order by login

I do have the same connection though so maybe this isn’t a solution for you