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



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

select from multiple records

  • Filter
  • Time
  • Show
Clear All
new posts

  • select from multiple records

    i am stuck on a little problem. i have a set in which a child table records clients address over the last 3 years. there are usually 2 or more addresses for each parent.

    in the parent table is fields to record the clients correspondence address (can only ever be 1 correspondence address), which may be one of the addresses already recorded in the child table.

    i would like to give my user the option to select from one of these addresses and have been playing with ideas on how to do this.

    so far i have a button which invokes a xdialog form. this form shows all of the addresses in the child table (trying to filter on current record) user selects address and then the correspondence address fields are populated with the values from the selected address.

    i am nearly there (i think). when i have created the xdialog, i seem to be only able to collect 1 of the values from the child record whereas there are 5 values i need. so effectively the only data i am passing to the correspondence address fields is the postcode.

    how can i pass all 5 fields across and how do i filter on the current record?


  • #2
    Re: select from multiple records

    more - ill try to simplify my problem.

    user presses button for parent record which runs a scipt to

    view child records
    user selects one record
    pass the field values of the chosen record to variables.

    set the values of the variables to fields in the parent record.

    i can do this using a form, but i thought there must be a better way using dialog or xdialog.

    hope this makes it a little clearer.


    • #3
      Re: select from multiple records


      I am not sure what object you are using for your list in the xdialog so I can not be specific.

      When you open the xdialog you can pass the current record key value to the list object, for example if your key value is ContactID, when you pass this to the xdialog, it will filter your list to the current value of ContactID.

      Now, for the other problem, you are only getting the one value because the list object is only returning one value. Again, depending on the list object your using dictates how to handle multiple values. If you can return multiple values from the list object, you would then need to use a delimiter so you can parse the return out.

      Here is a quick example:
      Let's say your list object returns Address, City, State, Zip .. it should look something like:

      Then you would parse it out:
      Address = word(return,1,"^")
      City = word(return,2,"^")
      State = word(return,3,"^")
      Zip = word(return,4,"^")

      Now if you can not return multiple values from the list object, you can do the same thing by using Lookup() with your return value to get the rest of your values and then parse it out.

      Hope this helps ... hard to answer with out knowing what you have



      • #4
        Re: select from multiple records

        i scott,

        thanks for your help. helped me undestand xdialog a bit better and i was able to create a record select list with all of the fields, however i could see no way of pasisng all 5 fields to vaiable for use in other fields.

        if the correspondence address i was populating was maybe a rtf object with no other user input, i feel this owuld have worked fine, but sometimes the correspondence address could be different to those already entered.

        in the end, i just created a small form with a browse filtered to the current parent record. then i added button to collect the values in to variables and pass these to the parent form.

        i just tried to use dialog as i have read a bit about them and they seem to be the way forward for user interaction.

        thanks again



        • #5
          Re: select from multiple records

          For the sake of completeness, the attached is an example of what Scott was referring to using an Xdialog and delimited list box addresses.
          Mike W
          "I rebel in at least small things to express to the world that I have not completely surrendered"


          • #6
            Re: select from multiple records


            this is exactly what i was trying to achieve. in this portion of your code

            'show choice in text box
            dim vheader as C
            vheader = "Chosen address" + crlf() + "===========================" + crlf() 
            ' adjust for no add2 value
            dim vaddpick as C
            if vadd2 = "" then
            	vaddpick = vadd1 + crlf() + vcity + space(3) + vstate + space(3) + vzip
            	vaddpick = vadd1 + crlf() + vadd2 + crlf() + vcity + space(3) + vstate + space(3) + vzip
            end if
            parentform:Text1.text = vheader + vaddpick
            END FUNCTION
            i am thinking that i can use these variables to populate fields in the parent form rather than populate the rtf object.

            in terms of performance or design is there greater benefit from this method over the method i ended up with. (open form with filtered browse, select record, click button which gets values into variables, set values on parent form from variables and closes form).




            • #7
              Re: select from multiple records

              Actually Richard,
              I guess I am not seeing why this Browse to select the addresses can't or isn't on the original form as it is in the example.

              But, as far as performance, both the xdialog script and opening a second form result in opening another instance of the child table, filtered. The xdialog script is probably a bit faster, but a form and a browse offer more capabilities that are easier to produce on the object (style, buttons, secondary scripts, etc).
              Mike W
              "I rebel in at least small things to express to the world that I have not completely surrendered"


              • #8
                Re: select from multiple records


                your right, it is in the original form and i dont know why i didnt just use this for setting the correspondence address fields. they are even on the same page. guess i just had it in my head that the way i have done it was the way to do it.

                i do need to use this feature again later to populate the mortgaged property address fields which is in a different page, so i guess this is where it will come in useful.

                thanks again