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

transfer data from one field&table to another same name field different table

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

    transfer data from one field&table to another same name field different table

    Could someone please tell me how to (I'm sure its elementary - I'm very new) automatically fill in a field on a child table from a parent table with the same-named field? The tables are in a set and linked by Record ID. If needed, more detail: Parent table [ADDRESS FILE] has [RECORD ID] field, [NAME] field, [ADDRESS] field, then other fields relating to address info. Child table [MEMBER INFO] has [RECORD ID] field, [NAME] field, [ADDRESS] field, then other info relating to their membership. When a person becomes a member, their [ADDRESS FILE] record is opened and their membership level is entered. This creates a new record on the [MEMBERSHIP INFO] table. When the new record is created, I want the [NAME] and [ADDRESS] fields to automatically fill in, based on the common [RECORD ID]. Please, if I am going about this the wrong way, advise me...I have separate tables because I do not want [MEMBER AMOUNT DONATED] field from [MEMBERSHIP INFO] table to show on [ADDRESS FILE] table.
    Lauren
    Tags: None
    #2
    Re: transfer data from one field&table to another same name field different table

    Your post raises questions about the advisability of maintaining duplicate field values in multiple tables. When a member's address changes are you going to handle the change in the ADDRESS FILE or in the MEMBER INFO table? Or are you planning to make the changes twice each time someone moves or the postal service assigns a new zip code? Often it's best to keep biographic and census data in a single place since it's far easier to maintain. On the other hand, sometimes folks work from prospect lists which function as lookup tables by supplying field values to transaction records when needed.

    Leaving that aside for the moment, there are several different ways the field values from one table can be passed to a new record in the second table. Tell us more about the forms you will be using and the exact sequence the user will be following. Will data entry be done using forms based on single tables or on a form based on your set? Is the set linkage one to one or one to many? Tell us how the data will be maintained as changes occur later on.

    Is there any chance you could post a working copy of your database here so we can see exactly what you're attempting? We don't need actual data or many records. A representative sample of dummy records would suffice.

    Comment

      #3
      Re: transfer data from one field&table to another same name field different table

      I'm in over my head...
      I can send database if I knew how.
      I want to be able to use either table in the set to edit address info, with entry into either table posting to corresponding record in other table. I am intending to build form for membership to edit/update their own data, using the membership table, but edits to address will also post back to address table. Conversely, I want address table to populate the field in membership table so that there is a record for them to start validation of data from, so they are only editing, not creating.
      The intent right now is for there to be a master address file, with a field on address file showing if they are a member. Then, if member, they will populate their own table, having name and address fields in the membership table that are the same as in address file. I want edits to be able to be made in either table, mostly so that the person who enters membership info cannot mess up all address files, only membership address file. And, do not want people who access address file to be able to see how much donated for membership.
      Should I just have one table and make this more reasonable???
      I intend to have them all using forms for data entry, and have address file as parent table with membership and personal info tables linked as a set.

      Comment

        #4
        Re: transfer data from one field&table to another same name field different table

        I think I need to create a form for membership. The form will use data from set (Address file:parent / Membership:child / Personal:child). Then when membership edits data on form it will feed back to ADDRESS FILE table, which will feed edited info to BIO form used by general public, without allowing general public access to all info on membership table.

        Am I correct that a separate form would solve this?

        Can I secure access to forms or only databases?

        HUGE learning curve here, I work in SPSS, this is foreign !!!

        Thanks

        Comment

          #5
          Re: transfer data from one field&table to another same name field different table

          Lauren, it's beginning to get confusing here, too. You started off with two tables and now mention a third. It's sounding as though you are building a web app that individual members would update using their browser, is that correct?

          Instead of trying to describe your situation in technical terms, give us a detailed description of what the user would see, and what you want to happen when they enter or update their information. the more details the better.

          Comment

            #6
            Re: transfer data from one field&table to another same name field different table

            The result I wanted was achieved by creating a form, based on the linked table set, that allowed viewing and updating from the Address file table, but only displays the portion of data that membership needed to see.

            Thanks for the help!

            Comment

              #7
              Re: transfer data from one field&table to another same name field different table

              Lauren, Tom,
              I will chime in here if you don't mind.

              I believe you MUST answer Tom's question first. Are you developing a desktop application that will be used by others, either on a single machine, or networked environment, or are you developing a web application?

              The intent right now is for there to be a master address file with a field on address file showing if they are a member. Then, if member, they will populate their own table, having name and address fields in the membership table that are the same as in address file. I want edits to be able to be made in either table, mostly so that the person who enters membership info cannot mess up all address files, only membership address file.
              Secondly, you are throwing out the term "file". In database terms, would that be a record? I believe I understand what you are looking for. Tell me if this is what you want:

              The member will interact with the database with a login of some type that will identify them as a member. They will then be presented with their record that exists in the master Address table, and their record present in the Member table. The master address table is read only, and select fields will be present for their viewing. The membership table, the member has priviledge to change/edit. This action will enter the information into a member table, not changing the master table.

              Am I on track so far?
              Mike W
              __________________________
              "I rebel in at least small things to express to the world that I have not completely surrendered"

              Comment

                #8
                Re: transfer data from one field&table to another same name field different table

                I am working in a desktop application. In the post you reference, file and table were interchangeable.
                I have a database set up for use by a small, startup nonprofit. Our goal is to hold many address records (in ADDRESS table) for many different mailing purposes. The first use of the address records was to mail membership applications. Once the applications came back, the info collected is to be put into the database using the MEMBERSHIP table. On the MEM table, I originally had fields for NAME and ADDRESS, that I thought would get filled in via link to ADDRESS table, which is the parent table and shares the field RECORD ID with the MEM table. Using the RECORD ID field, I thought that the MEM table would 'pull over' NAME data from ADDRESS table and display it in the MEM table NAME field. It seems that posting would accomplish this, but I wanted MEM table to further be able to edit NAME field and have it actually update ADDRESS table NAME field as well. The only records edited would be those of members, but the records would be updated within the entire database, not only on the MEM table NAME field.
                (There are 3 tables linked as a set: ADDRESS, MEMBERSHIP, PERSONAL. Personal is of little use in this scenario and is only being mentioned as to it being in the set.)
                SOLUTION: Instead of having NAME field on MEM table as well as on ADDRESS table, I created a form based on the set ADDRESS/MEM/PERSONAL. Using the form, I can show only data on the form that I need, the updates do not need to post because they are actually at the ADDRESS table, and a report compiled of any field from the set (NAME from ADDRESS table and MEMBER AMOUNT DONATED from MEM table) can be generated, displaying all of the data from records as needed.
                This eliminates duplicate NAME records, yet allows only people with MEM access to view donation amount on a 'person's name' basis.
                Being very new, and an SPSS user, I didn't come up with this right away, but - elementary!
                Lauren

                Comment

                  #9
                  Re: transfer data from one field&table to another same name field different table

                  In case you haven't discovered it already, there's a template database called "Membership Manager" in the templates subfolder in the A5v8 program files directory. It illustrates a way to organize your membership into various subgroups, a way to track transactions for each member (could be dues or donations), and includes a series of reports. Much of it might be useful to you.

                  Comment

                    #10
                    Re: transfer data from one field&table to another same name field different table

                    Thank you, Tom - this may become very useful!
                    Lauren

                    Comment

                    Previous template Next
                    Working...
                    X