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