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

Forms Help

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

    Forms Help

    I haven't work on this form for a while so my memory is fuzzy in Alpha V.

    I have a form that allows a user to add a parent record and then populate the child tables in a set. The set is linked only on the property number field in a one to many relationship and no referential integrity.

    I have a field in both the parent and the child in this case that I want to be identical even though its not part of the linked set arrangement. Do I need to do something somewhere in the form itself, or do I need to be doing something in the field rules. I would also want to be able to update the child independently if I chose to. So, I think its a form feature I need that if I had a record, that the child's field that should be matching will be posting at the time the record is being created.

    Can you tell me what to do for this one?


    Thanks,


    Bruce Roberson
    Tags: None
    #2
    RE: Forms Help

    Bruce,

    If you base the form on the set, Alpha is generally smart enough to supply the link field value to each new child table record you enter through that same form. If the link field is a simple one field link this will work just fine. In fact, if you open the default form for the set you'll see that Alpha doesn't even bother to show the link field for you.

    If you choose to base a data entry form on a single table, then you'll have to supply the necessary link field value you need in order to have records there "link" to other tables.

    See the difference ?

    -- tom

    Comment

      #3
      RE: Forms Help

      Tom:

      I am doing the form based on the set, not the individual table. As I mentioned, it is supplying the linked field value.

      Parent Table consisting of the following fields:

      Property Number (This is the linking field)
      Property Name (this is not a linking field)

      Child Table consisting of the following fields:

      Property Number (This is the linking field)
      Prop_Name (This is not linked in the set, but I want the same info populated automatically when entering new records through the set.

      In other words, if I enter a new record and put 123 for the property number in the parent field, then when I tab down and put ABC into the Property Name field, I want to see 123 in the Property Number field of the child, and ABC in the Property Name field of the child even though the property name field is not part of the linking structure. In other words, I shouldn't have to key in the property name again for the child record.

      Does that make sense what I'm trying to accomplish?

      Thanks,


      Bruce

      Comment

        #4
        RE: Forms Help

        I suppose so.

        In your set based form the property number will be supplied automatically as new child table records are entered. However you won't be able to see it. This is a good thing. If force the display of the child table property number be sure to mark it read only in your form so the user won't be tempted to fiddle with it.

        If I wanted the property name to show up automatically I'd define a field rule in the child table. Instead of leaving the field 'user entered' I'd make it 'calculated' and use a lookup() function to retrieve the name, with the current property number as search key.

        -- tom

        Comment

          #5
          RE: Forms Help

          After considerable pains I got the field rules to work IF you do enter a record in the child table itself independent of the set.

          However, when using a tabbed form, and tabbing to the tab holding the property number, it pops in there, but the property name still refuses to cooperate.

          Why?


          LOOKUPC("F",PROPERTY_NUMBER,"Prop_Name","rrcetc.dbf","property_N")

          Thanks,


          Bruce

          Comment

            #6
            RE: Forms Help

            I don't see anything obviously wrong. You could post a working copy of the database here, with instructions telling us how to find the problem. This is probably the best way to get specific answers.

            -- tom

            Comment

              #7
              RE: Forms Help

              ok, here is the sample file which includes a "TXT" file to give what few instructions there are.

              Thanks,


              Bruce

              Comment

                #8
                RE: Forms Help

                Bruce, your calc field expression was fine. Alpha was waiting for you to enter a field value manually before autofilling the calc field (property name) in your browse.

                Unzip the attachment to an empty folder. I've modified the TM rate tab on your Property Setups form to show you another way to organize / present this.

                -- tom

                Comment

                Previous template Next
                Working...
                X