Alpha DevCon 2018
Results 1 to 3 of 3

Thread: Beyond Cascading Lists

  1. #1
    Member
    Real Name
    sandy garrett
    Join Date
    Apr 2000
    Location
    Near Philadelphia
    Posts
    571

    Default Beyond Cascading Lists

    In trying to make a lookup system, I made a model that hopefully is easier to understand than the real thing. Groups => Series => Subseries would work as a cascading lookup if there were fewer entries. A one to many to many set would work if there were not duplications. The enclosed setup actually does work, but it is a real bother to use.

    Maybe I just don't know how to use it - like after Ma gets to Massachusetts, how do you get to Qu for Quincy without scrolling all through the state?

  2. #2
    Member
    Real Name
    Pete Whittet
    Join Date
    Sep 2007
    Location
    UK
    Posts
    132

    Default Re: Beyond Cascading Lists

    One option would be to set up each of the three fields (Group, Series, Subseries) as separate table lookups. If you define them as "not a drop-down list", you can specify "unique records only", and if you position them as "sticky", you can drag them right next to the field in question, and then they remember where they should pop up next time.

    There is a potential problem of someone only changing one of the three fields, so to help guard against this, in the attached example, I added a couple of events to the fields on the form:
    - OnChange to Group, Series and Subseries, to automatically tab to the next field when changed, and
    - OnArrive to Series and Subseries, to automatically pop up the lookups as soon as the control gains focus.

    Not perfect, I know, but maybe it will help.

    Pete

  3. #3
    Member
    Real Name
    sandy garrett
    Join Date
    Apr 2000
    Location
    Near Philadelphia
    Posts
    571

    Default Re: Beyond Cascading Lists

    Excellent!!!

    The separate table lookups did it. I changed the entry method to accomodate our ladies, who are supposed to enter on purpose and not change by accident.

    The indices baffled me, though, until I saw that A5 was writing them.

    The Phorum comes through as usual. Many thanks.
    Last edited by Sandy Garrett; 10-17-2009 at 02:02 PM.

Similar Threads

  1. Cascading lists limit
    By Betsy in forum Alpha Five Version 8
    Replies: 13
    Last Post: 06-26-2014, 12:00 PM
  2. Cascading Print lists
    By Rick Sloan in forum Alpha Five Version 9 - Desktop Applications
    Replies: 5
    Last Post: 01-22-2009, 06:23 PM
  3. Cascading Lists (Field Rules)
    By peter284 in forum Alpha Five Version 8
    Replies: 1
    Last Post: 03-15-2007, 10:44 PM
  4. Populating Cascading Lists
    By John Castle in forum Alpha Five Version 5
    Replies: 6
    Last Post: 07-22-2005, 08:13 AM
  5. Cascading dropdown lists
    By patrick saunders in forum Alpha Five Version 6
    Replies: 5
    Last Post: 02-08-2005, 10:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •