Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook
Devcon 2020 Goes Virtual! LEARN MORE >

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Mapping Each Lookup Choice to a Different Table

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Mapping Each Lookup Choice to a Different Table

    The search part of my grid starts with a dropdown box that presents the state abbreviations from a lookup table. I have been able to show a list of towns in the next dropdown box using a cascading lookup, but this shows only the towns from one particular state on every state choice. How do I map each choice in the state field to a different town table? I suspect this involves using a variable in an expression, but I don't know exactly how to do that. Perhaps there is another way entirely of doing this.
    Tags: None
    #2
    Re: Mapping Each Lookup Choice to a Different Table

    I have been trying to follow the document from the Alphapedia Wiki titled
    "Cascading Selection Lists", but when I try to construct a filter expression for parameter mapping, I get an error message saying "Parameter mapping is not permitted. Please remove any ? from the Filter Expression and replace with a constant.", so the mapping doesn't come up and I can't continue. Has this version of A5 changed or have I missed doing something?

    Comment

      #3
      Re: Mapping Each Lookup Choice to a Different Table

      Originally posted by ronc8 View Post
      I have been trying to follow the document from the Alphapedia Wiki titled
      "Cascading Selection Lists", but when I try to construct a filter expression for parameter mapping, I get an error message saying "Parameter mapping is not permitted. Please remove any ? from the Filter Expression and replace with a constant.", so the mapping doesn't come up and I can't continue. Has this version of A5 changed or have I missed doing something?
      i am not sure what wiki article you are referring to but it sounds like an old article that describes how to do cascading lookups in a DIALOG component.

      doing cascading lookups in a GRID is substantially easier and does not involve using 'parameters'. you simply define the lookup source for each dropdown (without any concern about filters) and then click the 'cascading dropdown' checkbox on the child lookups. there should be a video on this.

      Comment

        #4
        Re: Mapping Each Lookup Choice to a Different Table

        Selwyn, I know I'm probably getting to be a thorn in your side, but when you say, "There should be a video on this.", how come you don't put a link to the video? Or, if there's Help about something, how about a link to the appropriate Help. Or, if you say "You're not appreciating the difference between client and server..." which I've seen you do several times, how about directing the person to some Help document that will help them understand the difference? I think that would make things so much easier for all that are doing their best to learn your software.
        Carol King
        Developer of Custom Homebuilders' Solutions (CHS)
        http://www.CHSBuilderSoftware.com

        Comment

          #5
          Re: Mapping Each Lookup Choice to a Different Table

          Cascading drop down boxes are discussed in Alpha Five Web Applications Made Easy, The Basics and More for Version 10.5 (p. 268). There are also references to the video (#18a).

          We also discuss the Client / Server model in general (p. 109) and specifically as "client-side" and "server-side" pertain to calculations (p. 136) and in other relevant places.

          In defense of Selwyn's responses, it can be very time consuming to locate the references and I, personally, want him to keep on doing what he does best: Making Alpha Five better and better!

          To learn more about this book, click here.
          sigpic Susan Bush, Liberty Manuals Co. Books for Alpha Anywhere mobile, web and desktop.

          Comment

            #6
            Re: Mapping Each Lookup Choice to a Different Table

            Carol:
            I am like you, finding learning the web side of A5 a struggle due to lack of a comprehensive organized learning tool; BUT if you watch the videos (1-83 and the additional SSE1-SS12 videos) and practice what's in there you will learn a lot. The videos are really good, they don't (and can't) teach you everything, but they teach you a lot of things that can take you far enough in your project. The cascading feature is well covered in one of them. Here is the link to the series:
            http://news.alphasoftware.com/V10Preview/videos.htm

            Comment

              #7
              Re: Mapping Each Lookup Choice to a Different Table

              Originally posted by susanhbush View Post
              In defense of Selwyn's responses, it can be very time consuming to locate the references and I, personally, want him to keep on doing what he does best: Making Alpha Five better and better!
              Agreed
              Bill Griffin
              Parkell, Inc

              Comment

                #8
                Re: Mapping Each Lookup Choice to a Different Table

                I agree, also, about Selwyn needing to focus on the programming instead of running around to find references. Maybe he's wearing too many hats? I know the feeling actually, and the suggestion was not meant to be critical, just thought references might actually save time by helping learners get where they need to go without coming back and bugging him some more.

                I guess that as long as they don't have a comprehensive, organized learning tool and help stuff that separates desktop apps from web apps, there are going to be frustrated learners. Just thought it would hope those frustrated ones if they could get a quick reference to whatever is being suggested, since it is so hard to find.

                I did watch, pretty early on, all the videos. It's just that whenever a reference is made to one, it would be great not to have to go back and search through 90 or so of them to find what I need to review again. AND, I had a some difficulty finding the videos in the first place... so a quick reference would make all the difference in the world.

                Maybe the Alpha support team should have some list of videos sitting beside them with their hyperlinks for quick copy/paste.
                Carol King
                Developer of Custom Homebuilders' Solutions (CHS)
                http://www.CHSBuilderSoftware.com

                Comment

                  #9
                  Re: Mapping Each Lookup Choice to a Different Table

                  I have just learned over these years that if I send a tech support email to a clients, it's best to tell them where to go to do what I'm suggesting. This keeps them from calling back cuz they can't find it.

                  I always reply like this now... "First, go to the Vendor Ledger
                  (Home->Accounts Payalbe->Click Vendor Ledger on toolbar at top of page)." Then I tell them what to do when they get there.

                  Sometimes just saying things like "Use The Vendor Ledger" doesn't work, especially for newbies.

                  Just meant to suggest something that would save time by decreasing number of replying messages asking where to find what was referenced... etc.
                  Carol King
                  Developer of Custom Homebuilders' Solutions (CHS)
                  http://www.CHSBuilderSoftware.com

                  Comment

                    #10
                    Re: Mapping Each Lookup Choice to a Different Table

                    Originally posted by kingcarol View Post
                    Maybe the Alpha support team should have some list of videos sitting beside them with their hyperlinks for quick copy/paste.
                    I really like that suggestion, Carol.

                    The hard part for all of us is that we wear so many hats - I know that sure is the case for me. It's great that we can do so much ourselves, but that means we have to keep a lot of balls in the air.
                    sigpic Susan Bush, Liberty Manuals Co. Books for Alpha Anywhere mobile, web and desktop.

                    Comment

                    Previous template Next
                    Working...
                    X