Want to run a query to select custom field picker from another database
I would like to be able to select data choices for a custom field by running a query to return valid choices against a table in another database on the same server. For example, I have a database with customer orders against which I raise problem tickets. I want to be able to produce a drop down of valid order numbers for say the current day. There are too many to provide a drop down of all orders, and I don't really want to run a stored proc every minute or so in my other database to keep a table in Gemini up to date.
I've tried using a fully qualified SQL name (database | schema | table) but it didn't seem to work.
Is running a query or stored proc possible?
Better still, I'd want the query to contain selections based on other data entered into Gemini, for example a product type or the order date
cpf_jg
· 1 |
|
Wednesday, October 17, 2012, 6:13:43 PM |