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