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

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

Single record

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

    Single record

    How do I go about restricting a form to one record only and yet allow changes to be made if necessary?
    Kevin G. Timberlake
    Marvel Illusions

    #2
    Re: Single record

    Hi Kevin,

    All forms are single records unless you have a browse on it.

    You can make the form Read only in properties. You can have a button on the form to change a field to change details.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

    Comment


      #3
      Re: Single record

      I have a form for setting the company info. I only want them to be able to set the data for one company, so I need it to be restricted to one record only. I have been reading the help file and can't find how to restrict this.
      Kevin G. Timberlake
      Marvel Illusions

      Comment


        #4
        Re: Single record

        Kevin,
        don't think of a form of browses for that matter to 'have' recods. Tables have records. Forms and browses only display the records in the table. So your question I will interpret as how to restrict the table behind the form to only have one record yet be able to edit it.

        Supply the app with one blank record or with example data.
        In the field rules on the events(last) tab choose Record Events
        Then in the CanEnterRecord event place one line of code.

        Cancel()

        This is a special function you can use in all events that start with Can... in order to stop them from happening. The Can... events fire just before an action.
        Tim Kiebert
        Eagle Creek Citrus
        A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

        Comment


          #5
          Re: Single record

          Kevin, if you supply the customer with a specimen record, you can set a restriction in the properties of your form to prevent "enters". i.e. to prevent new records from being entered through that form. If you do this you probably want to restrict "deletes", as well.

          As you can see there are lots of options.

          -- tom

          Comment


            #6
            Re: Single record

            Originally posted by Tom Cone Jr View Post
            If you do this you probably want to restrict "deletes", as well.
            -- tom
            Tom,
            Good point.

            If in the fields rules place Cancel() in the CanDeteteRecord event
            Tim Kiebert
            Eagle Creek Citrus
            A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

            Comment


              #7
              Re: Single record

              And if you put an image reference field in this record, you can use that as the image for your other post (global variables). The end user can have a form that allows them to change the image that is displayed by right clicking the image and changing it.

              To include this record in a set with other tables, link from the primary table of the set using an expression of "A" as the linking expression for the parent and the child.

              The the table is available for the report and you don't need a global variable.
              Al Buchholz
              Bookwood Systems, LTD
              Weekly QReportBuilder Webinars Thursday 1 pm CST

              Occam's Razor - KISS
              Normalize till it hurts - De-normalize till it works.
              Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
              When we triage a problem it is much easier to read sample systems than to read a mind.
              "Make it as simple as possible, but not simpler."
              Albert Einstein

              http://www.iadn.com/images/media/iadn_member.png

              Comment


                #8
                Re: Single record

                Thanks Tom and Tim, That is exactly how I wanted it. Al, I set it up with "A" as the expression and nothing happens. Can you explain the use of the expression "A" and how it would relate to each other?

                You guys are all great, thanks so much.
                Kevin G. Timberlake
                Marvel Illusions

                Comment


                  #9
                  Re: Single record

                  Originally posted by Kevin G. Timberlake View Post
                  Thanks Tom and Tim, That is exactly how I wanted it. Al, I set it up with "A" as the expression and nothing happens. Can you explain the use of the expression "A" and how it would relate to each other?

                  You guys are all great, thanks so much.
                  Did you make the expression "A" for both the parent and the child?

                  This the same technique that Andy is describing to you in your other thread... That thread is linked to this thread so let's cross link them....
                  Al Buchholz
                  Bookwood Systems, LTD
                  Weekly QReportBuilder Webinars Thursday 1 pm CST

                  Occam's Razor - KISS
                  Normalize till it hurts - De-normalize till it works.
                  Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                  When we triage a problem it is much easier to read sample systems than to read a mind.
                  "Make it as simple as possible, but not simpler."
                  Albert Einstein

                  http://www.iadn.com/images/media/iadn_member.png

                  Comment


                    #10
                    Re: Single record

                    I sure did, exactly as told. But the global table fields do not show up on the linked.
                    Kevin G. Timberlake
                    Marvel Illusions

                    Comment


                      #11
                      Re: Single record

                      Originally posted by Kevin G. Timberlake View Post
                      I sure did, exactly as told. But the global table fields do not show up on the linked.
                      No the global fields won't show up on the list, but the fields from the single record will...... So those fields in the table will eliminate the need for global variables and allow you to have a field in the single table that is a image reference field for your image linkage......
                      Al Buchholz
                      Bookwood Systems, LTD
                      Weekly QReportBuilder Webinars Thursday 1 pm CST

                      Occam's Razor - KISS
                      Normalize till it hurts - De-normalize till it works.
                      Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                      When we triage a problem it is much easier to read sample systems than to read a mind.
                      "Make it as simple as possible, but not simpler."
                      Albert Einstein

                      http://www.iadn.com/images/media/iadn_member.png

                      Comment


                        #12
                        Re: Single record

                        Originally posted by Al Buchholz View Post
                        No the global fields won't show up on the list, but the fields from the single record will...... So those fields in the table will eliminate the need for global variables and allow you to have a field in the single table that is a image reference field for your image linkage......
                        Kevin

                        Please post an example so we are talking more realistically rather than theoretically.
                        Al Buchholz
                        Bookwood Systems, LTD
                        Weekly QReportBuilder Webinars Thursday 1 pm CST

                        Occam's Razor - KISS
                        Normalize till it hurts - De-normalize till it works.
                        Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                        When we triage a problem it is much easier to read sample systems than to read a mind.
                        "Make it as simple as possible, but not simpler."
                        Albert Einstein

                        http://www.iadn.com/images/media/iadn_member.png

                        Comment


                          #13
                          Re: Single record

                          Ok, here it is. I included the invoice, products, global table which holds company info and my goal is to make the logo appear in the header of the invoice once set in the globals form. However, the end user needs to be able to change it as needed.
                          Kevin G. Timberlake
                          Marvel Illusions

                          Comment


                            #14
                            Re: Single record

                            Originally posted by Kevin G. Timberlake View Post
                            Ok, here it is. I included the invoice, products, global table which holds company info and my goal is to make the logo appear in the header of the invoice once set in the globals form. However, the end user needs to be able to change it as needed.
                            Global-invoiceheaders.set (linked 1-m) is inverted and causing the problems.

                            Should be Invoiceheaders_Global.set

                            Make the invoice_header the parent and link 1-1 with Globals

                            ps - Start an object name with a letter and use only letters, numbers, and underscore in the name...
                            Al Buchholz
                            Bookwood Systems, LTD
                            Weekly QReportBuilder Webinars Thursday 1 pm CST

                            Occam's Razor - KISS
                            Normalize till it hurts - De-normalize till it works.
                            Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                            When we triage a problem it is much easier to read sample systems than to read a mind.
                            "Make it as simple as possible, but not simpler."
                            Albert Einstein

                            http://www.iadn.com/images/media/iadn_member.png

                            Comment


                              #15
                              Re: Single record

                              I did the change, but still no logo showing on the invoice report.
                              Kevin G. Timberlake
                              Marvel Illusions

                              Comment

                              Working...
                              X