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

Can you auto enter new rows from a table look up?

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

    Can you auto enter new rows from a table look up?

    I am trying to pick out a field from one row, and automatically enter in several fields in the same row, and have it automatcially enter in new rows below it with the information I want.

    Example: I want to pick a field from a "table look" up and be able to select 15 rows worth of information, and have it creat 14 new rows to put it in.
    Tags: None
    #2
    Re: Can you auto enter new rows from a table look up?

    Donovan, I've read your post several times and still have no clue what you're talking about. In part it sounds like you want to auto-fill fields in a single record. In part it sounds like you want to stuff 15 rows of information into 14 new rows. It's possible the lack of response to your post means that my confusion is shared by others. Can you clarify?

    Comment

      #3
      Re: Can you auto enter new rows from a table look up?

      Tom, you expressed exactly my understanding (or, more precisely, lack there of) of the man's post.
      Peter
      AlphaBase Solutions, LLC

       [email protected]
      https://www.alphabasesolutions.com

      Comment

        #4
        Re: Can you auto enter new rows from a table look up?

        Mornin' Peter,

        It's his first post. Hope he gets back to us.

        Regards,

        -- tom

        Comment

          #5
          Re: Can you auto enter new rows from a table look up?

          I THINK what he is asking is:
          1-In a table, when adding a new record he want to choose a value from a lookup window based on a certain field
          2-He then wants the remaining fields of the new record to be automatically populated (nothing unusual here)
          3-Then he wants alpha to add 14 more new records in which the value of the field in question is the same value he piked from the lookup window, but not populate any other fields.

          All in all, you will have 15 new records:
          1-The first one will have all fields populated based on the chosen value from the lookup window, and
          2-The other 14 records will only have the lookup field only populated while all other fields are blank.

          Maybe..

          Comment

            #6
            Re: Can you auto enter new rows from a table look up?

            Originally posted by G Gabriel View Post
            I THINK what he is asking is:
            1-In a table, when adding a new record he want to choose a value from a lookup window based on a certain field
            2-He then wants the remaining fields of the new record to be automatically populated (nothing unusual here)
            3-Then he wants alpha to add 14 more new records in which the value of the field in question is the same value he piked from the lookup window, but not populate any other fields.

            All in all, you will have 15 new records:
            1-The first one will have all fields populated based on the chosen value from the lookup window, and
            2-The other 14 records will only have the lookup field only populated while all other fields are blank.

            Maybe..

            That is just about what I am asking, except I want a total of 15 different records ... I know I am not doing a good job explaining this, but let me try again.

            I am trying to creat a wire list generator for building OEM machines. I want to create a table full of all the different components I use with the different pin outs. I want to be able to generate a new table by picking different components from a different table and have it autofill new rows.

            i.e.
            1. I have one component with 45 pins wich all do something different.
            2. I do not want to have to pick this component 45 times but I do want to have 45 rows of information.
            3. I am currently doing a table look up (where all my components are listed - several thousand), have the field I want to view, and then insert that record into the current field.
            4. I would like to be able to pick the component only once, and have it autofill the current record, and the next 44 rows of information based on that first pick. But each of the 45 rows will have different information (all from the same table).

            I hope this helps to clarify what I am trying to get accomplished. But again, I understand I am probably not doing the best job describing the problem.

            Comment

              #7
              Re: Can you auto enter new rows from a table look up?

              Originally posted by Reytek View Post
              4. I would like to be able to pick the component only once, and have it autofill the current record, and the next 44 rows of information based on that first pick. But each of the 45 rows will have different information (all from the same table).
              I would do this with xbasic. Rather than a standard lookup, do the lookup w. xdialog. Then use xbasic to populate the new 45 rows.
              Peter
              AlphaBase Solutions, LLC

               [email protected]
              https://www.alphabasesolutions.com

              Comment

                #8
                Re: Can you auto enter new rows from a table look up?

                Originally posted by Peter.Greulich View Post
                I would do this with xbasic. Rather than a standard lookup, do the lookup w. xdialog. Then use xbasic to populate the new 45 rows.
                Thank you.

                Comment

                  #9
                  Re: Can you auto enter new rows from a table look up?

                  If you are not familiar w. xbasic, you can do this w. Action Scripting. A little tedious perhaps, but doable.
                  Peter
                  AlphaBase Solutions, LLC

                   [email protected]
                  https://www.alphabasesolutions.com

                  Comment

                    #10
                    Re: Can you auto enter new rows from a table look up?

                    Originally posted by Peter.Greulich View Post
                    If you are not familiar w. xbasic, you can do this w. Action Scripting. A little tedious perhaps, but doable.
                    That is good to know, because I am not familiar with xbasic. I have been trying to do it with Action Scripting, but I have just started to learn it. I will keep at it, and hopefully can get it to work. Thanks again.

                    Comment

                      #11
                      Re: Can you auto enter new rows from a table look up?

                      Reytek,

                      Did you have any success with This Yet ??

                      Comment

                        #12
                        Re: Can you auto enter new rows from a table look up?

                        I have not had a chance to try this. I am going to try the tutorials on Action Scripting and see where I get. From reading the help categories, I suspected this was one of the ways to do it, but I wasn't sure. So it looks like I will have to learn Action Scripting and see where it brings me.

                        Comment

                          #13
                          Re: Can you auto enter new rows from a table look up?

                          It looks like it may work. This morning I played around with creating an action script from the pop-up editor so what I was thinking is:

                          1 - run a query on :
                          Name - Description of Item
                          or a particular category using the Vendor ID as the Category

                          2 - after query appears select all records if a Kit (based upon Unit of Measure) and the create the Invoice by the read of each record.

                          3 - after that, the user can edit/delete the line items individually if desired, save then print. In that way, I'm using the invoice file as more of a transaction record (since I'm really not billing anyone).. does this make sense ??

                          Comment

                          Previous template Next
                          Working...
                          X