Look up settings with multiple database connections


Im aware that an application like a Form app uses a database connection and its fields may use a different connection.
Im now trying to have a select field and its look up settings with multiple connections like a select union of at least two tables with similar structure from dynamically different databases.
Is it possible? Has anyone tried doing that? Thanks

This would probably work better on a Control form.
You gather all the relevant data for the “form” data in session vars and show them in their respective fields.
Then you can have selections based on different databases (I assume… have not tried)
The Control Application should give you the leeway to do this, rather than the Form Application

That is the safest way and is SC UPDATE Bugproof :wink: