Drop-down list from 2 databases

Applications Forms
#1

Hi,

​I have a field with select data type.

​In the lookup setting, I only can connect to 1 database.
​SQL:
​select id, employee from employee1

However, I have 2 databases (employee1 and employee2) containing employees from 2 regions and I need all their names from the 2 databases to be in the drop-down values.

​May someone kindly advise how can I go about doing it?

​Thanks.

#2

When you assign a lookup only one table can be used. But you can manually enter your own sql. So use the wizard to make a skeleton and then apply your own code.