Is it possible to do a multi-level menu using the search menu-type?

Mary
CIBER
Scott AFB, IL

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

I don't believe so. The only alternative I have found is have adjacent
character fields to represent the levels of your menu, where the
contents of the second field are dynamically determined by the contents
of the first. This takes up room on the screen, of course.

Regards,
Dave

--
Dave Seidman, Remedy Applications Administrator, dseidman@koz.com,
919-767-2026
KOZ.com - Reinventing Communities Online
5001 South Miami Blvd., Suite 200, Durham, NC 27703


"Dollus, Mary" wrote:

> Hi all,
> Is it possible to do a multi-level menu using the search menu-type?
>
> Mary
> CIBER
> Scott AFB, IL
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

That's the only way I can think of too, but it won't work in this case, :(



-----Original Message-----
From: David Seidman [mailto:dseidman@KOZ.COM]
Sent: Mon, Sep 20, 1999 3:32 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


Hi Mary,
I don't believe so. The only alternative I have found is have adjacent
character fields to represent the levels of your menu, where the
contents of the second field are dynamically determined by the contents
of the first. This takes up room on the screen, of course.

Regards,
Dave

--
Dave Seidman, Remedy Applications Administrator, dseidman@koz.com,
919-767-2026
KOZ.com - Reinventing Communities Online
5001 South Miami Blvd., Suite 200, Durham, NC 27703


"Dollus, Mary" wrote:

> Hi all,
> Is it possible to do a multi-level menu using the search menu-type?
>
> Mary
> CIBER
> Scott AFB, IL
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

The user is presented with one selection list after the other.
I've done 3 levels this way and our users have found it works well. How many levels are you considering?

Larry Salisbury
Remedy Administrator
Litton Enterprise Solutions
e-mail salisburyl@littonles.com
voice: 818-715-5679
fax: 818-715-5218

Subject to the Year 2000 Information and Readiness Disclosure Act (Public Law 105-271)



-----Original Message-----
From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
Sent: Monday, September 20, 1999 13:14
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: multi-level menu
Importance: Low

Hi all,
Is it possible to do a multi-level menu using the search menu-type?

Mary
CIBER
Scott AFB, IL

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

that you could make pull right query menus. I've never tried this, but
there is something about compiling the "driver" in the API/source directory
on the server, and using the create menu function. One caveat is that you
can't build or open this menu in the admin tool or it will corrupt. This
isn't much to go on (from my own very limited notes of a few years ago),
but perhaps it will jog the memory of someone else with more knowledge of this.

Ryan

At 04:14 PM 9/20/99 -0400, you wrote:
>Hi all,
>Is it possible to do a multi-level menu using the search menu-type?
>
>Mary
>CIBER
>Scott AFB, IL
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist

_____________________________________
Ryan Frazier
University Information Systems Helpdesk/Remedy Administrator
Harvard University
617 496-3490
ryan_frazier@harvard.edu
remadmin@camail2.harvard.edu

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

number of situations.

The first level or two might be static, but for each static item, you
associate a query menu. There are some problems however with using a query
menu which
references the current screen--they do not work in all cases (can't remember
which, it might only be direct SQL menus).

I would belive that the driver program can do it for you. Or you could write
your own API program to do it--but the ARLoadARQualifierStruct function cannot
handle parsing quals that reference the current screen--you have to build the
structures manually.

--matt





Ryan Frazier on 09/20/99 04:06:43 PM

Please respond to "Action Request System discussion list(ARSList)"



To: ARSLIST@LISTSERV.VISTAIT.COM
cc:
Subject: Re: multi-level menu




At an advance topics seminar at RUG '98, they breifly talked about a way
that you could make pull right query menus. I've never tried this, but
there is something about compiling the "driver" in the API/source directory
on the server, and using the create menu function. One caveat is that you
can't build or open this menu in the admin tool or it will corrupt. This
isn't much to go on (from my own very limited notes of a few years ago),
but perhaps it will jog the memory of someone else with more knowledge of
this.

Ryan

At 04:14 PM 9/20/99 -0400, you wrote:
>Hi all,
>Is it possible to do a multi-level menu using the search menu-type?
>
>Mary
>CIBER
>Scott AFB, IL
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist

_____________________________________
Ryan Frazier
University Information Systems Helpdesk/Remedy Administrator
Harvard University
617 496-3490
ryan_frazier@harvard.edu
remadmin@camail2.harvard.edu

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

2 levels - the first will search another remedy table and the criteria is
'Individual's Status' = "Present-Available", and will list a group, the
second will list the people's names associated with that group:
ex:
IBM
Ted
Jan
Kim
ORACLE
Bob
Sam
Lexi
REMEDY
Tom
Bill
Fred

Does that make sense??
Thanks,
Mary

-----Original Message-----
From: Salisbury, Larry [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
Sent: Mon, Sep 20, 1999 4:11 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu



Mary, in a sense, yes. By creating multiple Search menus and creating a
series of active links to do the search. The menu button on the field
triggers the first search. The menu choice triggers the second & subsequent
searches which are controlled by execution order. You can use the single
target result field for each search or a hidden field.

The user is presented with one selection list after the other.
I've done 3 levels this way and our users have found it works well. How many
levels are you considering?

Larry Salisbury
Remedy Administrator
Litton Enterprise Solutions
e-mail salisburyl@littonles.com
voice: 818-715-5679
fax: 818-715-5218

Subject to the Year 2000 Information and Readiness Disclosure Act (Public
Law 105-271)



BM__MailData-----Original Message-----
From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
Sent: Monday, September 20, 1999 13:14
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: multi-level menu
Importance: Low

Hi all,
Is it possible to do a multi-level menu using the search menu-type?

Mary
CIBER
Scott AFB, IL

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Now, what if the user makes a mistake and chooses the wrong group in the
first place, like IBM instead of ORACLE, and there are different people
assigned to each group. When the user clicks on the menu button a third
time, it says there's no menu to display.

Any ideas?
Thanks,
Mary
:)

-----Original Message-----
From: Salisbury, Larry [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
Sent: Mon, Sep 20, 1999 4:11 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu



Mary, in a sense, yes. By creating multiple Search menus and creating a
series of active links to do the search. The menu button on the field
triggers the first search. The menu choice triggers the second & subsequent
searches which are controlled by execution order. You can use the single
target result field for each search or a hidden field.

The user is presented with one selection list after the other.
I've done 3 levels this way and our users have found it works well. How many
levels are you considering?

Larry Salisbury
Remedy Administrator
Litton Enterprise Solutions
e-mail salisburyl@littonles.com
voice: 818-715-5679
fax: 818-715-5218

Subject to the Year 2000 Information and Readiness Disclosure Act (Public
Law 105-271)



BM__MailData-----Original Message-----
From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
Sent: Monday, September 20, 1999 13:14
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: multi-level menu
Importance: Low

Hi all,
Is it possible to do a multi-level menu using the search menu-type?

Mary
CIBER
Scott AFB, IL

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

resets the menu?

Garron Christie

The Kemtah Group Inc.
onsite @
Sandia National Labs

(505)284-2122
gchrist@sandia.gov




> -----Original Message-----
> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> Sent: September 20, 1999 4:52 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> Larry, THANKS, got that part to work... :)
> Now, what if the user makes a mistake and chooses the wrong
> group in the
> first place, like IBM instead of ORACLE, and there are
> different people
> assigned to each group. When the user clicks on the menu
> button a third
> time, it says there's no menu to display.
>
> Any ideas?
> Thanks,
> Mary
> :)
>
> -----Original Message-----
> From: Salisbury, Larry
> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> Sent: Mon, Sep 20, 1999 4:11 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
>
> Mary, in a sense, yes. By creating multiple Search menus and
> creating a
> series of active links to do the search. The menu button on the field
> triggers the first search. The menu choice triggers the
> second & subsequent
> searches which are controlled by execution order. You can use
> the single
> target result field for each search or a hidden field.
>
> The user is presented with one selection list after the other.
> I've done 3 levels this way and our users have found it works
> well. How many
> levels are you considering?
>
> Larry Salisbury
> Remedy Administrator
> Litton Enterprise Solutions
> e-mail salisburyl@littonles.com
> voice: 818-715-5679
> fax: 818-715-5218
>
> Subject to the Year 2000 Information and Readiness Disclosure
> Act (Public
> Law 105-271)
>
>
>
> BM__MailData-----Original Message-----
> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> Sent: Monday, September 20, 1999 13:14
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: multi-level menu
> Importance: Low
>
> Hi all,
> Is it possible to do a multi-level menu using the search menu-type?
>
> Mary
> CIBER
> Scott AFB, IL
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

I can try that, but I know that the users will object, if they have to take
another step.

On the third attempt, the message "No Menu To Display" appears at the
bottom. Is there a way to capture that or use that in the run if so that if
it sees that message it can reset the menu to original menu?

Thanks,
Mary

-----Original Message-----
From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
Sent: Mon, Sep 20, 1999 6:58 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


How about a hidden button that comes visible after the 3rd select that
resets the menu?

Garron Christie

The Kemtah Group Inc.
onsite @
Sandia National Labs

(505)284-2122
gchrist@sandia.gov




> -----Original Message-----
> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> Sent: September 20, 1999 4:52 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> Larry, THANKS, got that part to work... :)
> Now, what if the user makes a mistake and chooses the wrong
> group in the
> first place, like IBM instead of ORACLE, and there are
> different people
> assigned to each group. When the user clicks on the menu
> button a third
> time, it says there's no menu to display.
>
> Any ideas?
> Thanks,
> Mary
> :)
>
> -----Original Message-----
> From: Salisbury, Larry
> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> Sent: Mon, Sep 20, 1999 4:11 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
>
> Mary, in a sense, yes. By creating multiple Search menus and
> creating a
> series of active links to do the search. The menu button on the field
> triggers the first search. The menu choice triggers the
> second & subsequent
> searches which are controlled by execution order. You can use
> the single
> target result field for each search or a hidden field.
>
> The user is presented with one selection list after the other.
> I've done 3 levels this way and our users have found it works
> well. How many
> levels are you considering?
>
> Larry Salisbury
> Remedy Administrator
> Litton Enterprise Solutions
> e-mail salisburyl@littonles.com
> voice: 818-715-5679
> fax: 818-715-5218
>
> Subject to the Year 2000 Information and Readiness Disclosure
> Act (Public
> Law 105-271)
>
>
>
> BM__MailData-----Original Message-----
> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> Sent: Monday, September 20, 1999 13:14
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: multi-level menu
> Importance: Low
>
> Hi all,
> Is it possible to do a multi-level menu using the search menu-type?
>
> Mary
> CIBER
> Scott AFB, IL
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Maybe I'm not following what you're attempting, but I think you may be
making it harder than you need to.

Here's an example. Assuming you have the following in some table:

Group | Member | Available?
-----------------------------
GroupA | Member1 | No
GroupA | Member2 | Yes
GroupA | Member3 | Yes
GroupB | Member4 | No
GroupB | Member5 | No
GroupC | Member6 | Yes
GroupC | Member7 | Yes
GroupC | Member8 | Yes

Attach a menu to your field that searches the above table with a Label and
Value field of Group, and a qualification of 'Available' = "Yes"

Then create an active link that fires on Menu/Row Choice of 'field' that
does a set fields to 'field'. That set fields action will query the above
table for $field$='Group' AND 'Available'="Yes", and set the field to
$Member$.

So only those groups with available members will show in the menu (Groups A
and C in this example) and once you choose a group, you are given a
selection list of the available members within that group. With more active
links this process could be continued many levels deep.

Now, how do you deal with users that choose the wrong group? Make sure you
have an entry for each group with a member name of "Cancel". If the user
chooses the wrong group, they can select "Cancel" and start over. You
should also create a filter that blocks the submit or modify if the field is
left equal to "Cancel".

Hope that helps-
-drake
dkeller@ar-experts.com

Drake Keller
Senior Systems Developer, Remedy Approved Consultant
AR Experts, LLC


>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Dollus, Mary
>Sent: Monday, September 20, 1999 8:57 PM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: multi-level menu
>Importance: Low
>
>
>Hi Garron,
>I can try that, but I know that the users will object, if they have to take
>another step.
>
>On the third attempt, the message "No Menu To Display" appears at the
>bottom. Is there a way to capture that or use that in the run if so that if
>it sees that message it can reset the menu to original menu?
>
>Thanks,
>Mary
>
>-----Original Message-----
>From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
>Sent: Mon, Sep 20, 1999 6:58 PM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: multi-level menu
>
>
>How about a hidden button that comes visible after the 3rd select that
>resets the menu?
>
>Garron Christie
>
>The Kemtah Group Inc.
>onsite @
>Sandia National Labs
>
>(505)284-2122
>gchrist@sandia.gov
>
>
>
>
>> -----Original Message-----
>> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
>> Sent: September 20, 1999 4:52 PM
>> To: ARSLIST@LISTSERV.VISTAIT.COM
>> Subject: Re: multi-level menu
>> Importance: Low
>>
>>
>> Larry, THANKS, got that part to work... :)
>> Now, what if the user makes a mistake and chooses the wrong
>> group in the
>> first place, like IBM instead of ORACLE, and there are
>> different people
>> assigned to each group. When the user clicks on the menu
>> button a third
>> time, it says there's no menu to display.
>>
>> Any ideas?
>> Thanks,
>> Mary
>> :)
>>
>> -----Original Message-----
>> From: Salisbury, Larry
>> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
>> Sent: Mon, Sep 20, 1999 4:11 PM
>> To: ARSLIST@LISTSERV.VISTAIT.COM
>> Subject: Re: multi-level menu
>>
>>
>>
>> Mary, in a sense, yes. By creating multiple Search menus and
>> creating a
>> series of active links to do the search. The menu button on the field
>> triggers the first search. The menu choice triggers the
>> second & subsequent
>> searches which are controlled by execution order. You can use
>> the single
>> target result field for each search or a hidden field.
>>
>> The user is presented with one selection list after the other.
>> I've done 3 levels this way and our users have found it works
>> well. How many
>> levels are you considering?
>>
>> Larry Salisbury
>> Remedy Administrator
>> Litton Enterprise Solutions
>> e-mail salisburyl@littonles.com
>> voice: 818-715-5679
>> fax: 818-715-5218
>>
>> Subject to the Year 2000 Information and Readiness Disclosure
>> Act (Public
>> Law 105-271)
>>
>>
>>
>> BM__MailData-----Original Message-----
>> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
>> Sent: Monday, September 20, 1999 13:14
>> To: ARSLIST@LISTSERV.VISTAIT.COM
>> Subject: multi-level menu
>> Importance: Low
>>
>> Hi all,
>> Is it possible to do a multi-level menu using the search menu-type?
>>
>> Mary
>> CIBER
>> Scott AFB, IL
>>
>> To Unsubscribe send e-mail to:
>> body of text is: unsubscribe arslist
>>
>> To Unsubscribe send e-mail to:
>> body of text is: unsubscribe arslist
>>
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

What works for us, and allows for reselecting from a menu is to have only
the first level selection from a menu. The second level is a set fields
from the result of the menu choice.

Example:
From the menu select IBM. An active link on return or menu choice performs
a set fields from the table where the query menu data is stored ($Field$ =
'LevelOne'). There will be multiple records with a 'LevelOne' of IBM, so
the user is presented with a picklist. Select Mary.

Oops, not IBM. Select again from the menu (there's only one menu associated
with the field), this time Oracle. Get a picklist of the records associated
with Oracle.

Susan
susan.blunt@trw.com



-----Original Message-----
From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
Sent: 20 September, 1999 17:57
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu
Importance: Low


Hi Garron,
I can try that, but I know that the users will object, if they have to take
another step.

On the third attempt, the message "No Menu To Display" appears at the
bottom. Is there a way to capture that or use that in the run if so that if
it sees that message it can reset the menu to original menu?

Thanks,
Mary

-----Original Message-----
From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
Sent: Mon, Sep 20, 1999 6:58 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


How about a hidden button that comes visible after the 3rd select that
resets the menu?

Garron Christie

The Kemtah Group Inc.
onsite @
Sandia National Labs

(505)284-2122
gchrist@sandia.gov




> -----Original Message-----
> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> Sent: September 20, 1999 4:52 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> Larry, THANKS, got that part to work... :)
> Now, what if the user makes a mistake and chooses the wrong
> group in the
> first place, like IBM instead of ORACLE, and there are
> different people
> assigned to each group. When the user clicks on the menu
> button a third
> time, it says there's no menu to display.
>
> Any ideas?
> Thanks,
> Mary
> :)
>
> -----Original Message-----
> From: Salisbury, Larry
> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> Sent: Mon, Sep 20, 1999 4:11 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
>
> Mary, in a sense, yes. By creating multiple Search menus and
> creating a
> series of active links to do the search. The menu button on the field
> triggers the first search. The menu choice triggers the
> second & subsequent
> searches which are controlled by execution order. You can use
> the single
> target result field for each search or a hidden field.
>
> The user is presented with one selection list after the other.
> I've done 3 levels this way and our users have found it works
> well. How many
> levels are you considering?
>
> Larry Salisbury
> Remedy Administrator
> Litton Enterprise Solutions
> e-mail salisburyl@littonles.com
> voice: 818-715-5679
> fax: 818-715-5218
>
> Subject to the Year 2000 Information and Readiness Disclosure
> Act (Public
> Law 105-271)
>
>
>
> BM__MailData-----Original Message-----
> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> Sent: Monday, September 20, 1999 13:14
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: multi-level menu
> Importance: Low
>
> Hi all,
> Is it possible to do a multi-level menu using the search menu-type?
>
> Mary
> CIBER
> Scott AFB, IL
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Thanks to all of you that gave me assistance!!

Guess what! I have it working so that it will pull the items from the
attached menu, then based on that it fires an active link that pulls the
names from the list that are associated with that group, BUT now I have a
new twist. (Of course)

What if the user wants to have the group remain in the field, (it's an
assigned to field and sometimes the user wants to notify the entire group vs
just one person.) So, the way it is working now, it will let you pull the
group name that is in the menu listing, and once it pulls the names, you can
select cancel and the group name will remain in the list. But if there is
only one name associated with that group, it automatically puts the name in
the field without a pick list.

So, I'm thinking that I can put a bogus name in there so two will always
appear on the list and they will HAVE to choose. Does that make sense?

Mary Dollus
CIBER
Scott AFB, IL
-----Original Message-----
From: Susan Blunt [mailto:Susan.Blunt@TRW.COM]
Sent: Tue, Sep 21, 1999 11:48 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


Mary -

What works for us, and allows for reselecting from a menu is to have only
the first level selection from a menu. The second level is a set fields
from the result of the menu choice.

Example:
From the menu select IBM. An active link on return or menu choice performs
a set fields from the table where the query menu data is stored ($Field$ =
'LevelOne'). There will be multiple records with a 'LevelOne' of IBM, so
the user is presented with a picklist. Select Mary.

Oops, not IBM. Select again from the menu (there's only one menu associated
with the field), this time Oracle. Get a picklist of the records associated
with Oracle.

Susan
susan.blunt@trw.com



-----Original Message-----
From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
Sent: 20 September, 1999 17:57
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu
Importance: Low


Hi Garron,
I can try that, but I know that the users will object, if they have to take
another step.

On the third attempt, the message "No Menu To Display" appears at the
bottom. Is there a way to capture that or use that in the run if so that if
it sees that message it can reset the menu to original menu?

Thanks,
Mary

-----Original Message-----
From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
Sent: Mon, Sep 20, 1999 6:58 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


How about a hidden button that comes visible after the 3rd select that
resets the menu?

Garron Christie

The Kemtah Group Inc.
onsite @
Sandia National Labs

(505)284-2122
gchrist@sandia.gov




> -----Original Message-----
> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> Sent: September 20, 1999 4:52 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> Larry, THANKS, got that part to work... :)
> Now, what if the user makes a mistake and chooses the wrong
> group in the
> first place, like IBM instead of ORACLE, and there are
> different people
> assigned to each group. When the user clicks on the menu
> button a third
> time, it says there's no menu to display.
>
> Any ideas?
> Thanks,
> Mary
> :)
>
> -----Original Message-----
> From: Salisbury, Larry
> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> Sent: Mon, Sep 20, 1999 4:11 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
>
> Mary, in a sense, yes. By creating multiple Search menus and
> creating a
> series of active links to do the search. The menu button on the field
> triggers the first search. The menu choice triggers the
> second & subsequent
> searches which are controlled by execution order. You can use
> the single
> target result field for each search or a hidden field.
>
> The user is presented with one selection list after the other.
> I've done 3 levels this way and our users have found it works
> well. How many
> levels are you considering?
>
> Larry Salisbury
> Remedy Administrator
> Litton Enterprise Solutions
> e-mail salisburyl@littonles.com
> voice: 818-715-5679
> fax: 818-715-5218
>
> Subject to the Year 2000 Information and Readiness Disclosure
> Act (Public
> Law 105-271)
>
>
>
> BM__MailData-----Original Message-----
> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> Sent: Monday, September 20, 1999 13:14
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: multi-level menu
> Importance: Low
>
> Hi all,
> Is it possible to do a multi-level menu using the search menu-type?
>
> Mary
> CIBER
> Scott AFB, IL
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Rick Cook
ISS Remedy Consultant
AT&T Wireless Services
425-580-8139

> -----Original Message-----
> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> Sent: Tuesday, September 21, 1999 11:51 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
> THANK YOU THANK YOU THANK YOU!
> Thanks to all of you that gave me assistance!!
>
> Guess what! I have it working so that it will pull the items from the
> attached menu, then based on that it fires an active link that pulls the
> names from the list that are associated with that group, BUT now I have a
> new twist. (Of course)
>
> What if the user wants to have the group remain in the field, (it's an
> assigned to field and sometimes the user wants to notify the entire group
> vs
> just one person.) So, the way it is working now, it will let you pull the
> group name that is in the menu listing, and once it pulls the names, you
> can
> select cancel and the group name will remain in the list. But if there is
> only one name associated with that group, it automatically puts the name
> in
> the field without a pick list.
>
> So, I'm thinking that I can put a bogus name in there so two will always
> appear on the list and they will HAVE to choose. Does that make sense?
>
> Mary Dollus
> CIBER
> Scott AFB, IL
> -----Original Message-----
> From: Susan Blunt [mailto:Susan.Blunt@TRW.COM]
> Sent: Tue, Sep 21, 1999 11:48 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
> Mary -
>
> What works for us, and allows for reselecting from a menu is to have only
> the first level selection from a menu. The second level is a set fields
> from the result of the menu choice.
>
> Example:
> From the menu select IBM. An active link on return or menu choice
> performs
> a set fields from the table where the query menu data is stored ($Field$ =
> 'LevelOne'). There will be multiple records with a 'LevelOne' of IBM, so
> the user is presented with a picklist. Select Mary.
>
> Oops, not IBM. Select again from the menu (there's only one menu
> associated
> with the field), this time Oracle. Get a picklist of the records
> associated
> with Oracle.
>
> Susan
> susan.blunt@trw.com
>
>
>
> -----Original Message-----
> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> Sent: 20 September, 1999 17:57
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> Hi Garron,
> I can try that, but I know that the users will object, if they have to
> take
> another step.
>
> On the third attempt, the message "No Menu To Display" appears at the
> bottom. Is there a way to capture that or use that in the run if so that
> if
> it sees that message it can reset the menu to original menu?
>
> Thanks,
> Mary
>
> -----Original Message-----
> From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
> Sent: Mon, Sep 20, 1999 6:58 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
> How about a hidden button that comes visible after the 3rd select that
> resets the menu?
>
> Garron Christie
>
> The Kemtah Group Inc.
> onsite @
> Sandia National Labs
>
> (505)284-2122
> gchrist@sandia.gov
>
>
>
>
> > -----Original Message-----
> > From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> > Sent: September 20, 1999 4:52 PM
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: Re: multi-level menu
> > Importance: Low
> >
> >
> > Larry, THANKS, got that part to work... :)
> > Now, what if the user makes a mistake and chooses the wrong
> > group in the
> > first place, like IBM instead of ORACLE, and there are
> > different people
> > assigned to each group. When the user clicks on the menu
> > button a third
> > time, it says there's no menu to display.
> >
> > Any ideas?
> > Thanks,
> > Mary
> > :)
> >
> > -----Original Message-----
> > From: Salisbury, Larry
> > [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> > Sent: Mon, Sep 20, 1999 4:11 PM
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: Re: multi-level menu
> >
> >
> >
> > Mary, in a sense, yes. By creating multiple Search menus and
> > creating a
> > series of active links to do the search. The menu button on the field
> > triggers the first search. The menu choice triggers the
> > second & subsequent
> > searches which are controlled by execution order. You can use
> > the single
> > target result field for each search or a hidden field.
> >
> > The user is presented with one selection list after the other.
> > I've done 3 levels this way and our users have found it works
> > well. How many
> > levels are you considering?
> >
> > Larry Salisbury
> > Remedy Administrator
> > Litton Enterprise Solutions
> > e-mail salisburyl@littonles.com
> > voice: 818-715-5679
> > fax: 818-715-5218
> >
> > Subject to the Year 2000 Information and Readiness Disclosure
> > Act (Public
> > Law 105-271)
> >
> >
> >
> > BM__MailData-----Original Message-----
> > From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> > Sent: Monday, September 20, 1999 13:14
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: multi-level menu
> > Importance: Low
> >
> > Hi all,
> > Is it possible to do a multi-level menu using the search menu-type?
> >
> > Mary
> > CIBER
> > Scott AFB, IL
> >
> > To Unsubscribe send e-mail to:
> > body of text is: unsubscribe arslist
> >
> > To Unsubscribe send e-mail to:
> > body of text is: unsubscribe arslist
> >
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

names. That will allow you to select the group or a user and will
always require a pick list to open.

-----Original Message-----
From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL]
Sent: Tuesday, September 21, 1999 2:51 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu
Importance: Low


THANK YOU THANK YOU THANK YOU!
Thanks to all of you that gave me assistance!!

Guess what! I have it working so that it will pull the items from the
attached menu, then based on that it fires an active link that pulls the
names from the list that are associated with that group, BUT now I have a
new twist. (Of course)

What if the user wants to have the group remain in the field, (it's an
assigned to field and sometimes the user wants to notify the entire group vs
just one person.) So, the way it is working now, it will let you pull the
group name that is in the menu listing, and once it pulls the names, you can
select cancel and the group name will remain in the list. But if there is
only one name associated with that group, it automatically puts the name in
the field without a pick list.

So, I'm thinking that I can put a bogus name in there so two will always
appear on the list and they will HAVE to choose. Does that make sense?

Mary Dollus
CIBER
Scott AFB, IL
-----Original Message-----
From: Susan Blunt [ mailto:Susan.Blunt@TRW.COM]
Sent: Tue, Sep 21, 1999 11:48 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


Mary -

What works for us, and allows for reselecting from a menu is to have only
the first level selection from a menu. The second level is a set fields
from the result of the menu choice.

Example:
From the menu select IBM. An active link on return or menu choice performs
a set fields from the table where the query menu data is stored ($Field$ =
'LevelOne'). There will be multiple records with a 'LevelOne' of IBM, so
the user is presented with a picklist. Select Mary.

Oops, not IBM. Select again from the menu (there's only one menu associated
with the field), this time Oracle. Get a picklist of the records associated
with Oracle.

Susan
susan.blunt@trw.com



-----Original Message-----
From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL]
Sent: 20 September, 1999 17:57
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu
Importance: Low


Hi Garron,
I can try that, but I know that the users will object, if they have to take
another step.

On the third attempt, the message "No Menu To Display" appears at the
bottom. Is there a way to capture that or use that in the run if so that if
it sees that message it can reset the menu to original menu?

Thanks,
Mary

-----Original Message-----
From: Christie, Garron [ mailto:gchrist@SANDIA.GOV]
Sent: Mon, Sep 20, 1999 6:58 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


How about a hidden button that comes visible after the 3rd select that
resets the menu?

Garron Christie

The Kemtah Group Inc.
onsite @
Sandia National Labs

(505)284-2122
gchrist@sandia.gov




> -----Original Message-----
> From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL]
> Sent: September 20, 1999 4:52 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> Larry, THANKS, got that part to work... :)
> Now, what if the user makes a mistake and chooses the wrong group in the
> first place, like IBM instead of ORACLE, and there are different people
> assigned to each group. When the user clicks on the menu button a third
> time, it says there's no menu to display.
>
> Any ideas?
> Thanks,
> Mary
> :)
>
> -----Original Message-----
> From: Salisbury, Larry
> [ mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> Sent: Mon, Sep 20, 1999 4:11 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
>
> Mary, in a sense, yes. By creating multiple Search menus and creating a
> series of active links to do the search. The menu button on the field
> triggers the first search. The menu choice triggers the second & subsequent
> searches which are controlled by execution order. You can use the single
> target result field for each search or a hidden field.
>
> The user is presented with one selection list after the other.
> I've done 3 levels this way and our users have found it works well. How many
> levels are you considering?
>
> Larry Salisbury
> Remedy Administrator
> Litton Enterprise Solutions
> e-mail < mailto:salisburyl@littonles.com> salisburyl@littonles.com
> voice: 818-715-5679
> fax: 818-715-5218
>
> Subject to the Year 2000 Information and Readiness Disclosure
> Act (Public
> Law 105-271)
>
>
>
> BM__MailData-----Original Message-----
> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> Sent: Monday, September 20, 1999 13:14
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: multi-level menu
> Importance: Low
>
> Hi all,
> Is it possible to do a multi-level menu using the search menu-type?
>
> Mary
> CIBER
> Scott AFB, IL

Glenn, how do I include the group name with the user's names?

Thanks,
Mary

-----Original Message-----
From: Botts, Glenn [mailto:BottsG@STATE.GOV]
Sent: Tue, Sep 21, 1999 2:53 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu



Change your query so that the group name is included with the user's
names. That will allow you to select the group or a user and will
always require a pick list to open.

-----Original Message-----
From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL
]
Sent: Tuesday, September 21, 1999 2:51 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu
Importance: Low


THANK YOU THANK YOU THANK YOU!
Thanks to all of you that gave me assistance!!

Guess what! I have it working so that it will pull the items from the
attached menu, then based on that it fires an active link that pulls the
names from the list that are associated with that group, BUT now I have a
new twist. (Of course)

What if the user wants to have the group remain in the field, (it's an
assigned to field and sometimes the user wants to notify the entire group vs

just one person.) So, the way it is working now, it will let you pull the
group name that is in the menu listing, and once it pulls the names, you can

select cancel and the group name will remain in the list. But if there is
only one name associated with that group, it automatically puts the name in
the field without a pick list.

So, I'm thinking that I can put a bogus name in there so two will always
appear on the list and they will HAVE to choose. Does that make sense?

Mary Dollus
CIBER
Scott AFB, IL
-----Original Message-----
From: Susan Blunt [ mailto:Susan.Blunt@TRW.COM
]
Sent: Tue, Sep 21, 1999 11:48 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


Mary -

What works for us, and allows for reselecting from a menu is to have only
the first level selection from a menu. The second level is a set fields
from the result of the menu choice.

Example:
From the menu select IBM. An active link on return or menu choice performs
a set fields from the table where the query menu data is stored ($Field$ =
'LevelOne'). There will be multiple records with a 'LevelOne' of IBM, so
the user is presented with a picklist. Select Mary.

Oops, not IBM. Select again from the menu (there's only one menu associated

with the field), this time Oracle. Get a picklist of the records associated

with Oracle.

Susan
susan.blunt@trw.com



-----Original Message-----
From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL
]
Sent: 20 September, 1999 17:57
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu
Importance: Low


Hi Garron,
I can try that, but I know that the users will object, if they have to take
another step.

On the third attempt, the message "No Menu To Display" appears at the
bottom. Is there a way to capture that or use that in the run if so that if
it sees that message it can reset the menu to original menu?

Thanks,
Mary

-----Original Message-----
From: Christie, Garron [ mailto:gchrist@SANDIA.GOV
]
Sent: Mon, Sep 20, 1999 6:58 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


How about a hidden button that comes visible after the 3rd select that
resets the menu?

Garron Christie

The Kemtah Group Inc.
onsite @
Sandia National Labs

(505)284-2122
gchrist@sandia.gov




> -----Original Message-----
> From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL
]
> Sent: September 20, 1999 4:52 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> Larry, THANKS, got that part to work... :)
> Now, what if the user makes a mistake and chooses the wrong group in the
> first place, like IBM instead of ORACLE, and there are different people
> assigned to each group. When the user clicks on the menu button a third
> time, it says there's no menu to display.
>
> Any ideas?
> Thanks,
> Mary
> :)
>
> -----Original Message-----
> From: Salisbury, Larry
> [ mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM
]
> Sent: Mon, Sep 20, 1999 4:11 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
>
> Mary, in a sense, yes. By creating multiple Search menus and creating a
> series of active links to do the search. The menu button on the field
> triggers the first search. The menu choice triggers the second &
subsequent
> searches which are controlled by execution order. You can use the single
> target result field for each search or a hidden field.
>
> The user is presented with one selection list after the other.
> I've done 3 levels this way and our users have found it works well. How
many
> levels are you considering?
>
> Larry Salisbury
> Remedy Administrator
> Litton Enterprise Solutions
> e-mail < mailto:salisburyl@littonles.com
> salisburyl@littonles.com
> voice: 818-715-5679
> fax: 818-715-5218
>
> Subject to the Year 2000 Information and Readiness Disclosure
> Act (Public
> Law 105-271)
>
>
>
> BM__MailData-----Original Message-----
> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> Sent: Monday, September 20, 1999 13:14
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: multi-level menu
> Importance: Low
>
> Hi all,
> Is it possible to do a multi-level menu using the search menu-type?
>
> Mary
> CIBER
> Scott AFB, IL

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

choosing a person, or choosing to leave it assigned to the group-

-drake
dkeller@ar-experts.com

Drake Keller
Senior Systems Developer, Remedy Approved Consultant
AR Experts, LLC


>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Dollus, Mary
>Sent: Tuesday, September 21, 1999 2:51 PM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: multi-level menu
>Importance: Low
>
>
>THANK YOU THANK YOU THANK YOU!
>Thanks to all of you that gave me assistance!!
>
>Guess what! I have it working so that it will pull the items from the
>attached menu, then based on that it fires an active link that pulls the
>names from the list that are associated with that group, BUT now I have a
>new twist. (Of course)
>
>What if the user wants to have the group remain in the field, (it's an
>assigned to field and sometimes the user wants to notify the
>entire group vs
>just one person.) So, the way it is working now, it will let you pull the
>group name that is in the menu listing, and once it pulls the
>names, you can
>select cancel and the group name will remain in the list. But if there is
>only one name associated with that group, it automatically puts the name in
>the field without a pick list.
>
>So, I'm thinking that I can put a bogus name in there so two will always
>appear on the list and they will HAVE to choose. Does that make sense?
>
>Mary Dollus
>CIBER
>Scott AFB, IL
>-----Original Message-----
>From: Susan Blunt [mailto:Susan.Blunt@TRW.COM]
>Sent: Tue, Sep 21, 1999 11:48 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: multi-level menu
>
>
>Mary -
>
>What works for us, and allows for reselecting from a menu is to have only
>the first level selection from a menu. The second level is a set fields
>from the result of the menu choice.
>
>Example:
>From the menu select IBM. An active link on return or menu choice performs
>a set fields from the table where the query menu data is stored ($Field$ =
>'LevelOne'). There will be multiple records with a 'LevelOne' of IBM, so
>the user is presented with a picklist. Select Mary.
>
>Oops, not IBM. Select again from the menu (there's only one menu
>associated
>with the field), this time Oracle. Get a picklist of the records
>associated
>with Oracle.
>
>Susan
>susan.blunt@trw.com
>
>
>
>-----Original Message-----
>From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
>Sent: 20 September, 1999 17:57
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: multi-level menu
>Importance: Low
>
>
>Hi Garron,
>I can try that, but I know that the users will object, if they have to take
>another step.
>
>On the third attempt, the message "No Menu To Display" appears at the
>bottom. Is there a way to capture that or use that in the run if so that if
>it sees that message it can reset the menu to original menu?
>
>Thanks,
>Mary
>
>-----Original Message-----
>From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
>Sent: Mon, Sep 20, 1999 6:58 PM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: multi-level menu
>
>
>How about a hidden button that comes visible after the 3rd select that
>resets the menu?
>
>Garron Christie
>
>The Kemtah Group Inc.
>onsite @
>Sandia National Labs
>
>(505)284-2122
>gchrist@sandia.gov
>
>
>
>
>> -----Original Message-----
>> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
>> Sent: September 20, 1999 4:52 PM
>> To: ARSLIST@LISTSERV.VISTAIT.COM
>> Subject: Re: multi-level menu
>> Importance: Low
>>
>>
>> Larry, THANKS, got that part to work... :)
>> Now, what if the user makes a mistake and chooses the wrong
>> group in the
>> first place, like IBM instead of ORACLE, and there are
>> different people
>> assigned to each group. When the user clicks on the menu
>> button a third
>> time, it says there's no menu to display.
>>
>> Any ideas?
>> Thanks,
>> Mary
>> :)
>>
>> -----Original Message-----
>> From: Salisbury, Larry
>> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
>> Sent: Mon, Sep 20, 1999 4:11 PM
>> To: ARSLIST@LISTSERV.VISTAIT.COM
>> Subject: Re: multi-level menu
>>
>>
>>
>> Mary, in a sense, yes. By creating multiple Search menus and
>> creating a
>> series of active links to do the search. The menu button on the field
>> triggers the first search. The menu choice triggers the
>> second & subsequent
>> searches which are controlled by execution order. You can use
>> the single
>> target result field for each search or a hidden field.
>>
>> The user is presented with one selection list after the other.
>> I've done 3 levels this way and our users have found it works
>> well. How many
>> levels are you considering?
>>
>> Larry Salisbury
>> Remedy Administrator
>> Litton Enterprise Solutions
>> e-mail salisburyl@littonles.com
>> voice: 818-715-5679
>> fax: 818-715-5218
>>
>> Subject to the Year 2000 Information and Readiness Disclosure
>> Act (Public
>> Law 105-271)
>>
>>
>>
>> BM__MailData-----Original Message-----
>> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
>> Sent: Monday, September 20, 1999 13:14
>> To: ARSLIST@LISTSERV.VISTAIT.COM
>> Subject: multi-level menu
>> Importance: Low
>>
>> Hi all,
>> Is it possible to do a multi-level menu using the search menu-type?
>>
>> Mary
>> CIBER
>> Scott AFB, IL
>>
>> To Unsubscribe send e-mail to:
>> body of text is: unsubscribe arslist
>>
>> To Unsubscribe send e-mail to:
>> body of text is: unsubscribe arslist
>>
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

You could add a dummy entry in the schema with a user
name that matches the group. This probably isn't the
best idea if it's the user schema.
Your best bet is to use an SQL query that includes a
UNION that returns the group name.
example: SELECT user FROM schema WHERE group LIKE '%$group$'
UNION SELECT '$group$' ORDER BY 1

This query will vary depending on the database in use. If
you're querying the USER schema, then you'll need to alter
the query to get the group number from the GROUP table. If
you need additional help to do this, e-mail me directly.

-----Original Message-----
From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL]
Sent: Tuesday, September 21, 1999 4:05 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu
Importance: Low


???
Glenn, how do I include the group name with the user's names?

Thanks,
Mary

-----Original Message-----
From: Botts, Glenn [ mailto:BottsG@STATE.GOV]
Sent: Tue, Sep 21, 1999 2:53 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu



Change your query so that the group name is included with the user's
names. That will allow you to select the group or a user and will
always require a pick list to open.

-----Original Message-----
From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL
< mailto:DollusM@SCOTT.DISA.MIL> ]
Sent: Tuesday, September 21, 1999 2:51 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu
Importance: Low


THANK YOU THANK YOU THANK YOU!
Thanks to all of you that gave me assistance!!

Guess what! I have it working so that it will pull the items from the
attached menu, then based on that it fires an active link that pulls the
names from the list that are associated with that group, BUT now I have a
new twist. (Of course)

What if the user wants to have the group remain in the field, (it's an
assigned to field and sometimes the user wants to notify the entire group vs

just one person.) So, the way it is working now, it will let you pull the
group name that is in the menu listing, and once it pulls the names, you can

select cancel and the group name will remain in the list. But if there is
only one name associated with that group, it automatically puts the name in
the field without a pick list.

So, I'm thinking that I can put a bogus name in there so two will always
appear on the list and they will HAVE to choose. Does that make sense?

Mary Dollus
CIBER
Scott AFB, IL
-----Original Message-----
From: Susan Blunt [ mailto:Susan.Blunt@TRW.COM < mailto:Susan.Blunt@TRW.COM>
]
Sent: Tue, Sep 21, 1999 11:48 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


Mary -

What works for us, and allows for reselecting from a menu is to have only
the first level selection from a menu. The second level is a set fields
from the result of the menu choice.

Example:
From the menu select IBM. An active link on return or menu choice performs
a set fields from the table where the query menu data is stored ($Field$ =
'LevelOne'). There will be multiple records with a 'LevelOne' of IBM, so
the user is presented with a picklist. Select Mary.

Oops, not IBM. Select again from the menu (there's only one menu associated

with the field), this time Oracle. Get a picklist of the records associated

with Oracle.

Susan
susan.blunt@trw.com



-----Original Message-----
From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL
< mailto:DollusM@SCOTT.DISA.MIL> ]
Sent: 20 September, 1999 17:57
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu
Importance: Low


Hi Garron,
I can try that, but I know that the users will object, if they have to take
another step.

On the third attempt, the message "No Menu To Display" appears at the
bottom. Is there a way to capture that or use that in the run if so that if
it sees that message it can reset the menu to original menu?

Thanks,
Mary

-----Original Message-----
From: Christie, Garron [ mailto:gchrist@SANDIA.GOV
< mailto:gchrist@SANDIA.GOV> ]
Sent: Mon, Sep 20, 1999 6:58 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: multi-level menu


How about a hidden button that comes visible after the 3rd select that
resets the menu?

Garron Christie

The Kemtah Group Inc.
onsite @
Sandia National Labs

(505)284-2122
gchrist@sandia.gov




> -----Original Message-----
> From: Dollus, Mary [ mailto:DollusM@SCOTT.DISA.MIL
< mailto:DollusM@SCOTT.DISA.MIL> ]
> Sent: September 20, 1999 4:52 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> Larry, THANKS, got that part to work... :)
> Now, what if the user makes a mistake and chooses the wrong group in the
> first place, like IBM instead of ORACLE, and there are different people
> assigned to each group. When the user clicks on the menu button a third
> time, it says there's no menu to display.
>
> Any ideas?
> Thanks,
> Mary
> :)
>
> -----Original Message-----
> From: Salisbury, Larry
> [ mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM
< mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM> ]
> Sent: Mon, Sep 20, 1999 4:11 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
>
> Mary, in a sense, yes. By creating multiple Search menus and creating a
> series of active links to do the search. The menu button on the field
> triggers the first search. The menu choice triggers the second &
subsequent
> searches which are controlled by execution order. You can use the single
> target result field for each search or a hidden field.
>
> The user is presented with one selection list after the other.
> I've done 3 levels this way and our users have found it works well. How
many
> levels are you considering?
>
> Larry Salisbury
> Remedy Administrator
> Litton Enterprise Solutions
> e-mail < mailto:salisburyl@littonles.com
< mailto:salisburyl@littonles.com> > salisburyl@littonles.com
> voice: 818-715-5679
> fax: 818-715-5218
>
> Subject to the Year 2000 Information and Readiness Disclosure
> Act (Public
> Law 105-271)
>
>
>
> BM__MailData-----Original Message-----
> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> Sent: Monday, September 20, 1999 13:14
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: multi-level menu
> Importance: Low
>
> Hi all,
> Is it possible to do a multi-level menu using the search menu-type?
>
> Mary
> CIBER
> Scott AFB, IL

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

this may work. You could use the menu field to populate another field with
the group info, and the problem owner in the menu field. That way you would
be able to use either one. The menu field is used for the selection of
group. Once selected, the value is passed to the group field with a set
fields in the active link. Then the user is selected, or automatically
populated into the menu field. You could probably just have the group field
a Display Only field, unless it is critical to have the information kept
with the ticket. That way, both the group and owner information is
available.


Garron Christie
The Kemtah Group Inc.
onsite @
Sandia National Labs

(505)284-2122
gchrist@sandia.gov




> -----Original Message-----
> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> Sent: September 21, 1999 12:51 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> THANK YOU THANK YOU THANK YOU!
> Thanks to all of you that gave me assistance!!
>
> Guess what! I have it working so that it will pull the items from the
> attached menu, then based on that it fires an active link
> that pulls the
> names from the list that are associated with that group, BUT
> now I have a
> new twist. (Of course)
>
> What if the user wants to have the group remain in the field, (it's an
> assigned to field and sometimes the user wants to notify the
> entire group vs
> just one person.) So, the way it is working now, it will let
> you pull the
> group name that is in the menu listing, and once it pulls the
> names, you can
> select cancel and the group name will remain in the list. But
> if there is
> only one name associated with that group, it automatically
> puts the name in
> the field without a pick list.
>
> So, I'm thinking that I can put a bogus name in there so two
> will always
> appear on the list and they will HAVE to choose. Does that
> make sense?
>
> Mary Dollus
> CIBER
> Scott AFB, IL
> -----Original Message-----
> From: Susan Blunt [mailto:Susan.Blunt@TRW.COM]
> Sent: Tue, Sep 21, 1999 11:48 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
> Mary -
>
> What works for us, and allows for reselecting from a menu is
> to have only
> the first level selection from a menu. The second level is a
> set fields
> from the result of the menu choice.
>
> Example:
> From the menu select IBM. An active link on return or menu
> choice performs
> a set fields from the table where the query menu data is
> stored ($Field$ =
> 'LevelOne'). There will be multiple records with a
> 'LevelOne' of IBM, so
> the user is presented with a picklist. Select Mary.
>
> Oops, not IBM. Select again from the menu (there's only one
> menu associated
> with the field), this time Oracle. Get a picklist of the
> records associated
> with Oracle.
>
> Susan
> susan.blunt@trw.com
>
>
>
> -----Original Message-----
> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> Sent: 20 September, 1999 17:57
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
> Importance: Low
>
>
> Hi Garron,
> I can try that, but I know that the users will object, if
> they have to take
> another step.
>
> On the third attempt, the message "No Menu To Display" appears at the
> bottom. Is there a way to capture that or use that in the run
> if so that if
> it sees that message it can reset the menu to original menu?
>
> Thanks,
> Mary
>
> -----Original Message-----
> From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
> Sent: Mon, Sep 20, 1999 6:58 PM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Re: multi-level menu
>
>
> How about a hidden button that comes visible after the 3rd select that
> resets the menu?
>
> Garron Christie
>
> The Kemtah Group Inc.
> onsite @
> Sandia National Labs
>
> (505)284-2122
> gchrist@sandia.gov
>
>
>
>
> > -----Original Message-----
> > From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> > Sent: September 20, 1999 4:52 PM
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: Re: multi-level menu
> > Importance: Low
> >
> >
> > Larry, THANKS, got that part to work... :)
> > Now, what if the user makes a mistake and chooses the wrong
> > group in the
> > first place, like IBM instead of ORACLE, and there are
> > different people
> > assigned to each group. When the user clicks on the menu
> > button a third
> > time, it says there's no menu to display.
> >
> > Any ideas?
> > Thanks,
> > Mary
> > :)
> >
> > -----Original Message-----
> > From: Salisbury, Larry
> > [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> > Sent: Mon, Sep 20, 1999 4:11 PM
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: Re: multi-level menu
> >
> >
> >
> > Mary, in a sense, yes. By creating multiple Search menus and
> > creating a
> > series of active links to do the search. The menu button on
> the field
> > triggers the first search. The menu choice triggers the
> > second & subsequent
> > searches which are controlled by execution order. You can use
> > the single
> > target result field for each search or a hidden field.
> >
> > The user is presented with one selection list after the other.
> > I've done 3 levels this way and our users have found it works
> > well. How many
> > levels are you considering?
> >
> > Larry Salisbury
> > Remedy Administrator
> > Litton Enterprise Solutions
> > e-mail salisburyl@littonles.com
> > voice: 818-715-5679
> > fax: 818-715-5218
> >
> > Subject to the Year 2000 Information and Readiness Disclosure
> > Act (Public
> > Law 105-271)
> >
> >
> >
> > BM__MailData-----Original Message-----
> > From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> > Sent: Monday, September 20, 1999 13:14
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: multi-level menu
> > Importance: Low
> >
> > Hi all,
> > Is it possible to do a multi-level menu using the search menu-type?
> >
> > Mary
> > CIBER
> > Scott AFB, IL
> >
> > To Unsubscribe send e-mail to:
> > body of text is: unsubscribe arslist
> >
> > To Unsubscribe send e-mail to:
> > body of text is: unsubscribe arslist
> >
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

one field in a pick list, but on each subsequent search I want to display a
different field in the pick list, but from the same form? From my
understanding, the pick list fields are tied to the form's results list fields.
What would be the best way to handle this? The reason I am asking this is
because if I store all my data on one form, I am tied to the form's results list
fields. So if I wanted to add a few more set fields active links, I would have
to scroll through all the fields in the pick list to find the results I am
looking for. How does one handle this situation?


Drake wrote:

> Mary-
>
> Maybe I'm not following what you're attempting, but I think you may be
> making it harder than you need to.
>
> Here's an example. Assuming you have the following in some table:
>
> Group | Member | Available?
> -----------------------------
> GroupA | Member1 | No
> GroupA | Member2 | Yes
> GroupA | Member3 | Yes
> GroupB | Member4 | No
> GroupB | Member5 | No
> GroupC | Member6 | Yes
> GroupC | Member7 | Yes
> GroupC | Member8 | Yes
>
> Attach a menu to your field that searches the above table with a Label and
> Value field of Group, and a qualification of 'Available' = "Yes"
>
> Then create an active link that fires on Menu/Row Choice of 'field' that
> does a set fields to 'field'. That set fields action will query the above
> table for $field$='Group' AND 'Available'="Yes", and set the field to
> $Member$.
>
> So only those groups with available members will show in the menu (Groups A
> and C in this example) and once you choose a group, you are given a
> selection list of the available members within that group. With more active
> links this process could be continued many levels deep.
>
> Now, how do you deal with users that choose the wrong group? Make sure you
> have an entry for each group with a member name of "Cancel". If the user
> chooses the wrong group, they can select "Cancel" and start over. You
> should also create a filter that blocks the submit or modify if the field is
> left equal to "Cancel".
>
> Hope that helps-
> -drake
> dkeller@ar-experts.com
>
> Drake Keller
> Senior Systems Developer, Remedy Approved Consultant
> AR Experts, LLC
>
> >-----Original Message-----
> >From: Action Request System discussion list(ARSList)
> >[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Dollus, Mary
> >Sent: Monday, September 20, 1999 8:57 PM
> >To: ARSLIST@LISTSERV.VISTAIT.COM
> >Subject: Re: multi-level menu
> >Importance: Low
> >
> >
> >Hi Garron,
> >I can try that, but I know that the users will object, if they have to take
> >another step.
> >
> >On the third attempt, the message "No Menu To Display" appears at the
> >bottom. Is there a way to capture that or use that in the run if so that if
> >it sees that message it can reset the menu to original menu?
> >
> >Thanks,
> >Mary
> >
> >-----Original Message-----
> >From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
> >Sent: Mon, Sep 20, 1999 6:58 PM
> >To: ARSLIST@LISTSERV.VISTAIT.COM
> >Subject: Re: multi-level menu
> >
> >
> >How about a hidden button that comes visible after the 3rd select that
> >resets the menu?
> >
> >Garron Christie
> >
> >The Kemtah Group Inc.
> >onsite @
> >Sandia National Labs
> >
> >(505)284-2122
> >gchrist@sandia.gov
> >
> >
> >
> >
> >> -----Original Message-----
> >> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> >> Sent: September 20, 1999 4:52 PM
> >> To: ARSLIST@LISTSERV.VISTAIT.COM
> >> Subject: Re: multi-level menu
> >> Importance: Low
> >>
> >>
> >> Larry, THANKS, got that part to work... :)
> >> Now, what if the user makes a mistake and chooses the wrong
> >> group in the
> >> first place, like IBM instead of ORACLE, and there are
> >> different people
> >> assigned to each group. When the user clicks on the menu
> >> button a third
> >> time, it says there's no menu to display.
> >>
> >> Any ideas?
> >> Thanks,
> >> Mary
> >> :)
> >>
> >> -----Original Message-----
> >> From: Salisbury, Larry
> >> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> >> Sent: Mon, Sep 20, 1999 4:11 PM
> >> To: ARSLIST@LISTSERV.VISTAIT.COM
> >> Subject: Re: multi-level menu
> >>
> >>
> >>
> >> Mary, in a sense, yes. By creating multiple Search menus and
> >> creating a
> >> series of active links to do the search. The menu button on the field
> >> triggers the first search. The menu choice triggers the
> >> second & subsequent
> >> searches which are controlled by execution order. You can use
> >> the single
> >> target result field for each search or a hidden field.
> >>
> >> The user is presented with one selection list after the other.
> >> I've done 3 levels this way and our users have found it works
> >> well. How many
> >> levels are you considering?
> >>
> >> Larry Salisbury
> >> Remedy Administrator
> >> Litton Enterprise Solutions
> >> e-mail salisburyl@littonles.com
> >> voice: 818-715-5679
> >> fax: 818-715-5218
> >>
> >> Subject to the Year 2000 Information and Readiness Disclosure
> >> Act (Public
> >> Law 105-271)
> >>
> >>
> >>
> >> BM__MailData-----Original Message-----
> >> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> >> Sent: Monday, September 20, 1999 13:14
> >> To: ARSLIST@LISTSERV.VISTAIT.COM
> >> Subject: multi-level menu
> >> Importance: Low
> >>
> >> Hi all,
> >> Is it possible to do a multi-level menu using the search menu-type?
> >>
> >> Mary
> >> CIBER
> >> Scott AFB, IL
> >>
> >> To Unsubscribe send e-mail to:
> >> body of text is: unsubscribe arslist
> >>
> >> To Unsubscribe send e-mail to:
> >> body of text is: unsubscribe arslist
> >>
> >
> >To Unsubscribe send e-mail to:
> >body of text is: unsubscribe arslist
> >
> >To Unsubscribe send e-mail to:
> >body of text is: unsubscribe arslist
> >
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist

--
---------------------------------
Ron Tyro
Scotiabank Information Commons
University of Toronto
Phone: 416-978-0198
Fax: 416-978-0440
Email: ron.tyro@utoronto.ca
---------------------------------

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

list is that dynamic. It can be changed, but not on the fly... by
workflow...


-drake
dkeller@ar-experts.com

Drake Keller
Senior Systems Developer, Remedy Approved Consultant
AR Experts, LLC


>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ron Tyro
>Sent: Thursday, September 23, 1999 2:31 PM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: Re: multi-level menu
>
>
>I have one more question about this technique. What if I wanted
>to display only
>one field in a pick list, but on each subsequent search I want to display a
>different field in the pick list, but from the same form? From my
>understanding, the pick list fields are tied to the form's results
>list fields.
>What would be the best way to handle this? The reason I am asking this is
>because if I store all my data on one form, I am tied to the
>form's results list
>fields. So if I wanted to add a few more set fields active links,
>I would have
>to scroll through all the fields in the pick list to find the results I am
>looking for. How does one handle this situation?
>
>
>Drake wrote:
>
>> Mary-
>>
>> Maybe I'm not following what you're attempting, but I think you may be
>> making it harder than you need to.
>>
>> Here's an example. Assuming you have the following in some table:
>>
>> Group | Member | Available?
>> -----------------------------
>> GroupA | Member1 | No
>> GroupA | Member2 | Yes
>> GroupA | Member3 | Yes
>> GroupB | Member4 | No
>> GroupB | Member5 | No
>> GroupC | Member6 | Yes
>> GroupC | Member7 | Yes
>> GroupC | Member8 | Yes
>>
>> Attach a menu to your field that searches the above table with a
>Label and
>> Value field of Group, and a qualification of 'Available' = "Yes"
>>
>> Then create an active link that fires on Menu/Row Choice of 'field' that
>> does a set fields to 'field'. That set fields action will query
>the above
>> table for $field$='Group' AND 'Available'="Yes", and set the field to
>> $Member$.
>>
>> So only those groups with available members will show in the
>menu (Groups A
>> and C in this example) and once you choose a group, you are given a
>> selection list of the available members within that group. With
>more active
>> links this process could be continued many levels deep.
>>
>> Now, how do you deal with users that choose the wrong group?
>Make sure you
>> have an entry for each group with a member name of "Cancel". If the user
>> chooses the wrong group, they can select "Cancel" and start over. You
>> should also create a filter that blocks the submit or modify if
>the field is
>> left equal to "Cancel".
>>
>> Hope that helps-
>> -drake
>> dkeller@ar-experts.com
>>
>> Drake Keller
>> Senior Systems Developer, Remedy Approved Consultant
>> AR Experts, LLC
>>
>> >-----Original Message-----
>> >From: Action Request System discussion list(ARSList)
>> >[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Dollus, Mary
>> >Sent: Monday, September 20, 1999 8:57 PM
>> >To: ARSLIST@LISTSERV.VISTAIT.COM
>> >Subject: Re: multi-level menu
>> >Importance: Low
>> >
>> >
>> >Hi Garron,
>> >I can try that, but I know that the users will object, if they
>have to take
>> >another step.
>> >
>> >On the third attempt, the message "No Menu To Display" appears at the
>> >bottom. Is there a way to capture that or use that in the run
>if so that if
>> >it sees that message it can reset the menu to original menu?
>> >
>> >Thanks,
>> >Mary
>> >
>> >-----Original Message-----
>> >From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
>> >Sent: Mon, Sep 20, 1999 6:58 PM
>> >To: ARSLIST@LISTSERV.VISTAIT.COM
>> >Subject: Re: multi-level menu
>> >
>> >
>> >How about a hidden button that comes visible after the 3rd select that
>> >resets the menu?
>> >
>> >Garron Christie
>> >
>> >The Kemtah Group Inc.
>> >onsite @
>> >Sandia National Labs
>> >
>> >(505)284-2122
>> >gchrist@sandia.gov
>> >
>> >
>> >
>> >
>> >> -----Original Message-----
>> >> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
>> >> Sent: September 20, 1999 4:52 PM
>> >> To: ARSLIST@LISTSERV.VISTAIT.COM
>> >> Subject: Re: multi-level menu
>> >> Importance: Low
>> >>
>> >>
>> >> Larry, THANKS, got that part to work... :)
>> >> Now, what if the user makes a mistake and chooses the wrong
>> >> group in the
>> >> first place, like IBM instead of ORACLE, and there are
>> >> different people
>> >> assigned to each group. When the user clicks on the menu
>> >> button a third
>> >> time, it says there's no menu to display.
>> >>
>> >> Any ideas?
>> >> Thanks,
>> >> Mary
>> >> :)
>> >>
>> >> -----Original Message-----
>> >> From: Salisbury, Larry
>> >> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
>> >> Sent: Mon, Sep 20, 1999 4:11 PM
>> >> To: ARSLIST@LISTSERV.VISTAIT.COM
>> >> Subject: Re: multi-level menu
>> >>
>> >>
>> >>
>> >> Mary, in a sense, yes. By creating multiple Search menus and
>> >> creating a
>> >> series of active links to do the search. The menu button on the field
>> >> triggers the first search. The menu choice triggers the
>> >> second & subsequent
>> >> searches which are controlled by execution order. You can use
>> >> the single
>> >> target result field for each search or a hidden field.
>> >>
>> >> The user is presented with one selection list after the other.
>> >> I've done 3 levels this way and our users have found it works
>> >> well. How many
>> >> levels are you considering?
>> >>
>> >> Larry Salisbury
>> >> Remedy Administrator
>> >> Litton Enterprise Solutions
>> >> e-mail salisburyl@littonles.com
>> >> voice: 818-715-5679
>> >> fax: 818-715-5218
>> >>
>> >> Subject to the Year 2000 Information and Readiness Disclosure
>> >> Act (Public
>> >> Law 105-271)
>> >>
>> >>
>> >>
>> >> BM__MailData-----Original Message-----
>> >> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
>> >> Sent: Monday, September 20, 1999 13:14
>> >> To: ARSLIST@LISTSERV.VISTAIT.COM
>> >> Subject: multi-level menu
>> >> Importance: Low
>> >>
>> >> Hi all,
>> >> Is it possible to do a multi-level menu using the search menu-type?
>> >>
>> >> Mary
>> >> CIBER
>> >> Scott AFB, IL
>> >>
>> >> To Unsubscribe send e-mail to:
>> >> body of text is: unsubscribe arslist
>> >>
>> >> To Unsubscribe send e-mail to:
>> >> body of text is: unsubscribe arslist
>> >>
>> >
>> >To Unsubscribe send e-mail to:
>> >body of text is: unsubscribe arslist
>> >
>> >To Unsubscribe send e-mail to:
>> >body of text is: unsubscribe arslist
>> >
>>
>> To Unsubscribe send e-mail to:
>> body of text is: unsubscribe arslist
>
>--
>---------------------------------
>Ron Tyro
>Scotiabank Information Commons
>University of Toronto
>Phone: 416-978-0198
>Fax: 416-978-0440
>Email: ron.tyro@utoronto.ca
>---------------------------------
>
>To Unsubscribe send e-mail to:
>body of text is: unsubscribe arslist
>

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Just off the top of my head... untested.

In your menu table (form) have the following fields:

Column | Value | Parent Value

Column refers to the menu-field being selected ( Category, Type, Item,
etc...)
Value = Menu value
Parent Value = the previous column's value

Examples:
Menu on Category field does a set field from MenuForm.Value where 'Column' =
1
Menu on Type field does a set field from MenuForm.Value where 'Column' = 2
AND 'Parent Value' = $Category$ (value already selected in Category menu)
Menu on Item field does a set field from MenuForm.Value where 'Column' = 3
AND 'Parent Value' = $Type$ (value already selected in Type menu)

If this does indeed work, you would probably want to create a nice
configuration front end to maintain the menus.
I could see this getting pretty hairy.

If you decide to give this a try, please let me know how it turns out.
I am also going to give this a try, I am really intrigued by the concept and
I am sure that there are probably a few pitfalls that I haven't thought of.



----- Original Message -----
From: Ron Tyro
To:
Sent: Thursday, September 23, 1999 1:31 PM
Subject: Re: multi-level menu


I have one more question about this technique. What if I wanted to display
only
one field in a pick list, but on each subsequent search I want to display a
different field in the pick list, but from the same form? From my
understanding, the pick list fields are tied to the form's results list
fields.
What would be the best way to handle this? The reason I am asking this is
because if I store all my data on one form, I am tied to the form's results
list
fields. So if I wanted to add a few more set fields active links, I would
have
to scroll through all the fields in the pick list to find the results I am
looking for. How does one handle this situation?


Drake wrote:

> Mary-
>
> Maybe I'm not following what you're attempting, but I think you may be
> making it harder than you need to.
>
> Here's an example. Assuming you have the following in some table:
>
> Group | Member | Available?
> -----------------------------
> GroupA | Member1 | No
> GroupA | Member2 | Yes
> GroupA | Member3 | Yes
> GroupB | Member4 | No
> GroupB | Member5 | No
> GroupC | Member6 | Yes
> GroupC | Member7 | Yes
> GroupC | Member8 | Yes
>
> Attach a menu to your field that searches the above table with a Label and
> Value field of Group, and a qualification of 'Available' = "Yes"
>
> Then create an active link that fires on Menu/Row Choice of 'field' that
> does a set fields to 'field'. That set fields action will query the above
> table for $field$='Group' AND 'Available'="Yes", and set the field to
> $Member$.
>
> So only those groups with available members will show in the menu (Groups
A
> and C in this example) and once you choose a group, you are given a
> selection list of the available members within that group. With more
active
> links this process could be continued many levels deep.
>
> Now, how do you deal with users that choose the wrong group? Make sure
you
> have an entry for each group with a member name of "Cancel". If the user
> chooses the wrong group, they can select "Cancel" and start over. You
> should also create a filter that blocks the submit or modify if the field
is
> left equal to "Cancel".
>
> Hope that helps-
> -drake
> dkeller@ar-experts.com
>
> Drake Keller
> Senior Systems Developer, Remedy Approved Consultant
> AR Experts, LLC
>
> >-----Original Message-----
> >From: Action Request System discussion list(ARSList)
> >[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Dollus, Mary
> >Sent: Monday, September 20, 1999 8:57 PM
> >To: ARSLIST@LISTSERV.VISTAIT.COM
> >Subject: Re: multi-level menu
> >Importance: Low
> >
> >
> >Hi Garron,
> >I can try that, but I know that the users will object, if they have to
take
> >another step.
> >
> >On the third attempt, the message "No Menu To Display" appears at the
> >bottom. Is there a way to capture that or use that in the run if so that
if
> >it sees that message it can reset the menu to original menu?
> >
> >Thanks,
> >Mary
> >
> >-----Original Message-----
> >From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
> >Sent: Mon, Sep 20, 1999 6:58 PM
> >To: ARSLIST@LISTSERV.VISTAIT.COM
> >Subject: Re: multi-level menu
> >
> >
> >How about a hidden button that comes visible after the 3rd select that
> >resets the menu?
> >
> >Garron Christie
> >
> >The Kemtah Group Inc.
> >onsite @
> >Sandia National Labs
> >
> >(505)284-2122
> >gchrist@sandia.gov
> >
> >
> >
> >
> >> -----Original Message-----
> >> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> >> Sent: September 20, 1999 4:52 PM
> >> To: ARSLIST@LISTSERV.VISTAIT.COM
> >> Subject: Re: multi-level menu
> >> Importance: Low
> >>
> >>
> >> Larry, THANKS, got that part to work... :)
> >> Now, what if the user makes a mistake and chooses the wrong
> >> group in the
> >> first place, like IBM instead of ORACLE, and there are
> >> different people
> >> assigned to each group. When the user clicks on the menu
> >> button a third
> >> time, it says there's no menu to display.
> >>
> >> Any ideas?
> >> Thanks,
> >> Mary
> >> :)
> >>
> >> -----Original Message-----
> >> From: Salisbury, Larry
> >> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> >> Sent: Mon, Sep 20, 1999 4:11 PM
> >> To: ARSLIST@LISTSERV.VISTAIT.COM
> >> Subject: Re: multi-level menu
> >>
> >>
> >>
> >> Mary, in a sense, yes. By creating multiple Search menus and
> >> creating a
> >> series of active links to do the search. The menu button on the field
> >> triggers the first search. The menu choice triggers the
> >> second & subsequent
> >> searches which are controlled by execution order. You can use
> >> the single
> >> target result field for each search or a hidden field.
> >>
> >> The user is presented with one selection list after the other.
> >> I've done 3 levels this way and our users have found it works
> >> well. How many
> >> levels are you considering?
> >>
> >> Larry Salisbury
> >> Remedy Administrator
> >> Litton Enterprise Solutions
> >> e-mail salisburyl@littonles.com
> >> voice: 818-715-5679
> >> fax: 818-715-5218
> >>
> >> Subject to the Year 2000 Information and Readiness Disclosure
> >> Act (Public
> >> Law 105-271)
> >>
> >>
> >>
> >> BM__MailData-----Original Message-----
> >> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> >> Sent: Monday, September 20, 1999 13:14
> >> To: ARSLIST@LISTSERV.VISTAIT.COM
> >> Subject: multi-level menu
> >> Importance: Low
> >>
> >> Hi all,
> >> Is it possible to do a multi-level menu using the search menu-type?
> >>
> >> Mary
> >> CIBER
> >> Scott AFB, IL
> >>
> >> To Unsubscribe send e-mail to:
> >> body of text is: unsubscribe arslist
> >>
> >> To Unsubscribe send e-mail to:
> >> body of text is: unsubscribe arslist
> >>
> >
> >To Unsubscribe send e-mail to:
> >body of text is: unsubscribe arslist
> >
> >To Unsubscribe send e-mail to:
> >body of text is: unsubscribe arslist
> >
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist

--
---------------------------------
Ron Tyro
Scotiabank Information Commons
University of Toronto
Phone: 416-978-0198
Fax: 416-978-0440
Email: ron.tyro@utoronto.ca
---------------------------------

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

work. I can then just use one results list field in each of the 2 new views.
This seems to work well. Is this what you had in mind as well?

Drake wrote:

> Well, there you'd have a problem. I don't think the 'request lists fields'
> list is that dynamic. It can be changed, but not on the fly... by
> workflow...
>
> -drake
> dkeller@ar-experts.com
>
> Drake Keller
> Senior Systems Developer, Remedy Approved Consultant
> AR Experts, LLC
>
> >-----Original Message-----
> >From: Action Request System discussion list(ARSList)
> >[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Ron Tyro
> >Sent: Thursday, September 23, 1999 2:31 PM
> >To: ARSLIST@LISTSERV.VISTAIT.COM
> >Subject: Re: multi-level menu
> >
> >
> >I have one more question about this technique. What if I wanted
> >to display only
> >one field in a pick list, but on each subsequent search I want to display a
> >different field in the pick list, but from the same form? From my
> >understanding, the pick list fields are tied to the form's results
> >list fields.
> >What would be the best way to handle this? The reason I am asking this is
> >because if I store all my data on one form, I am tied to the
> >form's results list
> >fields. So if I wanted to add a few more set fields active links,
> >I would have
> >to scroll through all the fields in the pick list to find the results I am
> >looking for. How does one handle this situation?
> >
> >
> >Drake wrote:
> >
> >> Mary-
> >>
> >> Maybe I'm not following what you're attempting, but I think you may be
> >> making it harder than you need to.
> >>
> >> Here's an example. Assuming you have the following in some table:
> >>
> >> Group | Member | Available?
> >> -----------------------------
> >> GroupA | Member1 | No
> >> GroupA | Member2 | Yes
> >> GroupA | Member3 | Yes
> >> GroupB | Member4 | No
> >> GroupB | Member5 | No
> >> GroupC | Member6 | Yes
> >> GroupC | Member7 | Yes
> >> GroupC | Member8 | Yes
> >>
> >> Attach a menu to your field that searches the above table with a
> >Label and
> >> Value field of Group, and a qualification of 'Available' = "Yes"
> >>
> >> Then create an active link that fires on Menu/Row Choice of 'field' that
> >> does a set fields to 'field'. That set fields action will query
> >the above
> >> table for $field$='Group' AND 'Available'="Yes", and set the field to
> >> $Member$.
> >>
> >> So only those groups with available members will show in the
> >menu (Groups A
> >> and C in this example) and once you choose a group, you are given a
> >> selection list of the available members within that group. With
> >more active
> >> links this process could be continued many levels deep.
> >>
> >> Now, how do you deal with users that choose the wrong group?
> >Make sure you
> >> have an entry for each group with a member name of "Cancel". If the user
> >> chooses the wrong group, they can select "Cancel" and start over. You
> >> should also create a filter that blocks the submit or modify if
> >the field is
> >> left equal to "Cancel".
> >>
> >> Hope that helps-
> >> -drake
> >> dkeller@ar-experts.com
> >>
> >> Drake Keller
> >> Senior Systems Developer, Remedy Approved Consultant
> >> AR Experts, LLC
> >>
> >> >-----Original Message-----
> >> >From: Action Request System discussion list(ARSList)
> >> >[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Dollus, Mary
> >> >Sent: Monday, September 20, 1999 8:57 PM
> >> >To: ARSLIST@LISTSERV.VISTAIT.COM
> >> >Subject: Re: multi-level menu
> >> >Importance: Low
> >> >
> >> >
> >> >Hi Garron,
> >> >I can try that, but I know that the users will object, if they
> >have to take
> >> >another step.
> >> >
> >> >On the third attempt, the message "No Menu To Display" appears at the
> >> >bottom. Is there a way to capture that or use that in the run
> >if so that if
> >> >it sees that message it can reset the menu to original menu?
> >> >
> >> >Thanks,
> >> >Mary
> >> >
> >> >-----Original Message-----
> >> >From: Christie, Garron [mailto:gchrist@SANDIA.GOV]
> >> >Sent: Mon, Sep 20, 1999 6:58 PM
> >> >To: ARSLIST@LISTSERV.VISTAIT.COM
> >> >Subject: Re: multi-level menu
> >> >
> >> >
> >> >How about a hidden button that comes visible after the 3rd select that
> >> >resets the menu?
> >> >
> >> >Garron Christie
> >> >
> >> >The Kemtah Group Inc.
> >> >onsite @
> >> >Sandia National Labs
> >> >
> >> >(505)284-2122
> >> >gchrist@sandia.gov
> >> >
> >> >
> >> >
> >> >
> >> >> -----Original Message-----
> >> >> From: Dollus, Mary [mailto:DollusM@SCOTT.DISA.MIL]
> >> >> Sent: September 20, 1999 4:52 PM
> >> >> To: ARSLIST@LISTSERV.VISTAIT.COM
> >> >> Subject: Re: multi-level menu
> >> >> Importance: Low
> >> >>
> >> >>
> >> >> Larry, THANKS, got that part to work... :)
> >> >> Now, what if the user makes a mistake and chooses the wrong
> >> >> group in the
> >> >> first place, like IBM instead of ORACLE, and there are
> >> >> different people
> >> >> assigned to each group. When the user clicks on the menu
> >> >> button a third
> >> >> time, it says there's no menu to display.
> >> >>
> >> >> Any ideas?
> >> >> Thanks,
> >> >> Mary
> >> >> :)
> >> >>
> >> >> -----Original Message-----
> >> >> From: Salisbury, Larry
> >> >> [mailto:Larry_Salisbury@LESWHEX01.LITTONLCS.COM]
> >> >> Sent: Mon, Sep 20, 1999 4:11 PM
> >> >> To: ARSLIST@LISTSERV.VISTAIT.COM
> >> >> Subject: Re: multi-level menu
> >> >>
> >> >>
> >> >>
> >> >> Mary, in a sense, yes. By creating multiple Search menus and
> >> >> creating a
> >> >> series of active links to do the search. The menu button on the field
> >> >> triggers the first search. The menu choice triggers the
> >> >> second & subsequent
> >> >> searches which are controlled by execution order. You can use
> >> >> the single
> >> >> target result field for each search or a hidden field.
> >> >>
> >> >> The user is presented with one selection list after the other.
> >> >> I've done 3 levels this way and our users have found it works
> >> >> well. How many
> >> >> levels are you considering?
> >> >>
> >> >> Larry Salisbury
> >> >> Remedy Administrator
> >> >> Litton Enterprise Solutions
> >> >> e-mail salisburyl@littonles.com
> >> >> voice: 818-715-5679
> >> >> fax: 818-715-5218
> >> >>
> >> >> Subject to the Year 2000 Information and Readiness Disclosure
> >> >> Act (Public
> >> >> Law 105-271)
> >> >>
> >> >>
> >> >>
> >> >> BM__MailData-----Original Message-----
> >> >> From: Dollus, Mary [SMTP:DollusM@SCOTT.DISA.MIL]
> >> >> Sent: Monday, September 20, 1999 13:14
> >> >> To: ARSLIST@LISTSERV.VISTAIT.COM
> >> >> Subject: multi-level menu
> >> >> Importance: Low
> >> >>
> >> >> Hi all,
> >> >> Is it possible to do a multi-level menu using the search menu-type?
> >> >>
> >> >> Mary
> >> >> CIBER
> >> >> Scott AFB, IL
> >> >>
> >> >> To Unsubscribe send e-mail to:
> >> >> body of text is: unsubscribe arslist
> >> >>
> >> >> To Unsubscribe send e-mail to:
> >> >> body of text is: unsubscribe arslist
> >> >>
> >> >
> >> >To Unsubscribe send e-mail to:
> >> >body of text is: unsubscribe arslist
> >> >
> >> >To Unsubscribe send e-mail to:
> >> >body of text is: unsubscribe arslist
> >> >
> >>
> >> To Unsubscribe send e-mail to:
> >> body of text is: unsubscribe arslist
> >
> >--
> >---------------------------------
> >Ron Tyro
> >Scotiabank Information Commons
> >University of Toronto
> >Phone: 416-978-0198
> >Fax: 416-978-0440
> >Email: ron.tyro@utoronto.ca
> >---------------------------------
> >
> >To Unsubscribe send e-mail to:
> >body of text is: unsubscribe arslist
> >
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist

--
---------------------------------
Ron Tyro
Scotiabank Information Commons
University of Toronto
Phone: 416-978-0198
Fax: 416-978-0440
Email: ron.tyro@utoronto.ca
---------------------------------

To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist