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

Posting Survey

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Posting Survey

    Anyone who has been following my posting problems (opportunities?) may well be shaking youe head. Stan has been gracious to work with me on this. I would very much appreciate know how some of you handle this.

    1) Do you use the field rule post or the operations post?
    2) under what conditions do you use the field rule post?
    3) Under what conditions do you use the operations post?

    Perhaps I've mised something but I couldn't find anything in the manual anything that answers these questions.

    Thanks much,

    ken
    TYVM :) kenn

    Knowing what you can achieve will not become reality until you imagine and explore.

  • #2
    RE: Posting Survey

    1. Answered in two and three
    2. Field rule post. When you want to post information to another table. Example: You have a customer table and an accounting ledger table. In the customer table you have a field that is called Accounts Rec Balance (ARB). Whenever data is entered in the ledger as a debit, this amount is posted to the ARB as an addition. Whenever data is entered in the ledger as a credit, this amount is posted to the ARB as a subtraction. That way you have a running balance in the respective customer account. The ledger and customer table are linked using a field called ACCOUNT NUMBER.
    3. Operations Post, use this when you want to post massive data from one table to another. Example: you have a table that keeps track of the number of parts you sold in a month (part master) and a table that has the data that has the respective items that you did sell that month (parts sold). On the last day of the month you can use the operations post to update the the part master with the items you shipped that month.

    These are crude examples but I hope this helps a little.

    Comment


    • #3
      RE: Posting Survey

      Philip,

      Yes, that helps clarify the difference between the two. I know th manual gives similar examples but lacks an expalnation such as yours. My situation is more like your second example.

      Is it possible to post the posted fields to another field, say a total amount field?

      I've tried the simple calc expression, Fld1+Fld2+Fld3, etc. Total is 0.

      Thanks much,

      kenn
      TYVM :) kenn

      Knowing what you can achieve will not become reality until you imagine and explore.

      Comment


      • #4
        RE: Posting Survey

        1. Go to the table (MASTER) that has the data you want posted.
        2. Select the POST operation and go directly to posting (I do not use the genie)
        3. Select the TRANSACTION table (the destination table where you want the data to be posted)
        4. Select the LINKING FIELD between the two tables
        5. Click on FIELD, select FLD1, Operation, (add, subtract),Expression, select TOTAMOUNT field
        6. Click on FIELD, select FLD2, Operation, (add, subtract),Expression, select TOTAMOUNT field
        7. Click on FIELD, select FLD3, Operation, (add, subtract),Expression, select TOTAMOUNT field
        8. Click on the LIGHTENING BOLT and the operation should take place. If you had data of fld1=1 fld2=2 fld3=3 the totamt field should have the value of 6 (assuming that it was 0 prior to the post)

        Don't forget to select the records that you want posted prior to running the post.

        I can interpret your remark another way. If the TOTAMOUNT is is the SAME table as FLD1,2,3, use the calculate field rule for TOTAMOUNT. Go to field rules, select TOTAMOUNT, select data entry, select calculate and enter FLD1+FLD2+FLD3 and everytime you change data this field will be updated.

        Am I on the right track?


        Comment


        • #5
          RE: Posting Survey

          Philip,

          Yes, you've got the right idea. However, you're doing it the opposite way of what I was doing. I posted to the parent table (master) from the child table (trasnsaction). I understand you're saying to make the child table the master table for this operation.

          I'm not sure of what you mean in step 1 as I don't think it makes any difference as when the Operations tab is selected, a new task is started separate form anything done or selected in the past.

          I am going to give it a whirl. Will let you know how it comes out.

          Thanks,

          kenn
          TYVM :) kenn

          Knowing what you can achieve will not become reality until you imagine and explore.

          Comment


          • #6
            RE: Posting Survey

            Philip,

            I figured out that by selecting the table first, and then right clicking on it, one can create a posting operation. This is yet a 3rd way of doing it. Will work with this. Too many ways to do it without adequate documentation showing the differences between the different ways, leads to alot of confusion (my problem). Wouldn't a handy, dandy chart be nice?

            Will advise,

            kenn
            TYVM :) kenn

            Knowing what you can achieve will not become reality until you imagine and explore.

            Comment


            • #7
              RE: Posting Survey

              Ken,
              There are so many messages on this topic that I've lost tarack. Im not sure whether you got your posting to work. I downloaded your example tables and forms and got the posting to work properly with your field rules. If it still does not work for you, here are the steps you have to take:
              1) On p. 1 of your tabbed subform, change the Properties of the
              new Benefits IOP browse so that the primary table is "Issued".
              2) Make the change to the amount field in a child record.
              3) Press {F9} and then {F5}. {F5} will refresh the value in
              the TtlMFIP field.

              What build of A5v4 do you have? If you have build 240 or above,
              then it will not be necessary to press {F5} if you set the netwrork
              refresh interval to, say, 5 seconds. Unfortunately the
              network refresh interval wasn't working properly on earlier builds, so to see the changes to the underlying table you have to press {F5} .

              Comment


              • #8
                RE: Posting Survey

                Dr. Wayne,

                Thanks for your reply. My version is build 230 so will download the latest and then make the necessary corrections.

                Have you any thoughts for another training conference?

                Thanks,

                ken
                TYVM :) kenn

                Knowing what you can achieve will not become reality until you imagine and explore.

                Comment


                • #9
                  RE: Posting Survey

                  None at present, thank you.
                  - Peter Wayne

                  Comment

                  Working...
                  X