Here is one idea, you could create two menus and change them in an active link depending on your Category choice. Another idea but I am not sure it will work is this:
* Create table to data such as URL's, stored procedures. SQL statements, etc. * Each record should have a different Label or ID. * Create a display only field on your form that has your Categroy field on. * You will only need one menu and multiple active links. * In your menu you reference your display only field to pull the data. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ray Sent: Monday, July 30, 2007 7:58 AM To: [email protected] Subject: Re: Newbie help with creating a SQL menu..Making the SQL query context sensitive 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
