I have a situation where I would like a lookup field (to populate a Select box) to be a table in an entirely different database.
Any suggestions?
use linked table, hoping that remote database allow remote connection from the hosted web server.
Thanks - hadn’t thought of that.
The second database is on the same server so access should be ok.