Couple of suggestions: 1. Use two Menus. One for server and for data. When user selects from category you could change the menu with an Active Link Change action; you might also have to do this on Display of each record.
2. You could have the table name and column be dynamic based on the Category field. If the user chooses Data then set a temp field to REMEDY.LOCATIONSand another temp field to LOCATION; if Server then set a temp field to REMEDY.HOSTS and another temp field to HOSTNAME. Use the temp fields in the SQL statement: select distinct($temp_column$) from $temp_table$. On 7/30/07, Ray <[EMAIL PROTECTED]> wrote: > > Thank you. Will try that. > > One more question I have is: How do I make this menu context sensitive. > In other words. I have a field called Category with values Data and > Security. If the value is Data, I want to run a particular SQL query > (select distinct(LOCATION) from REMEDY.LOCATIONS). If the Value is > Security, I want to run a different SQL query (from a different table -> > select distinct(HOSTNAME) from REMEDY.HOSTS). I have reviewed the > example in training manual where it talks about building a context > sensitive menu assuming the target data is in another form. Will I have > create a form and join data from both the tables? > > Thanks > Ray > > Axton wrote: > > If you want to access a table in the same oracle instance, but in a > > different schema, use this syntax for the table name: > > <schema>.<tableName> > > > > If you want to access data in a remote schema, (1) create a database > > link in Oracle, then (2), use this syntax for the table name: > > > > <remoteSchema>.<tableName>@<DbLinkName> > > > > Axton Grams > > > > On 7/29/07, Ray <[EMAIL PROTECTED]> wrote: > > > >> Axton, Dave: I changed the Server name to the IP address of the remedy > >> server instead of the database server and it works. Any idea if I can > >> connect to a database table that is not the remedy database? If yes, > how > >> would I do that? > >> > >> Thanks > >> Ray > >> Shellman, David wrote: > >> > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
