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

Many to many links in a set, I think?

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

  • Many to many links in a set, I think?

    Iīm making an application for our tool/plant hire company. Iīm moving from, what I now think was probably my lash-up in A4, to hopefully something good in A5.

    We have clients; who are either firms, or private people, or something in-between, or sometimes thieves! The private people rent for themselves, so no problem. The firms have authorised people; drivers/supervisors/etc, who they authorize to sign rental contracts.
    So we have the situation sometimes where one firm has several staff, but also some of those people work for more than one firm, or work for themselves on weekends, etc.

    So a many to many set, sometimes both ways?

    So Iīm thinking the best way to sort it out is:-

    A set:-
    3 tables:- personlist, firmlist, linklist.

    personlist:- info of person, i.d. personal details etc.
    firmlist:- info of firm, address, tax no, tel/fax, vehicles, etc
    linklist:- a two field table linking persons to firms in both directions as required.

    In the case of a private person, his firm details would be his own address, etc.

    Then, I can make tables giving info of firms with all their staff; and a different table giving info of all the firms that any one person works for. Those are the tables I need to search on when a client wants to rent a machine.

    I would appreciate advice, is this a practical way to deal with our situation, or any other suggestions?

    Brian

  • #2
    RE: Many to many links in a set, I think?

    Hi again Brian,

    Here is one way to think about this. A many-to-many relation can be decomposed into two two one-to-many relations.

    For example, a student has many teachers and a teacher has many students so teachers to students is a many-to-many relation. This can be analyzed into
    1. Teachers to students 1:N (one to many), and
    2. Students to teachers 1:N.

    Relation #1 is commonly referred to as a classlist and #2 is called a transcript.

    Of course in a real academic records operation the setup would be much more complex but stripped down to the essentials we could capture both of the above relations using the same three tables:

    1-teachers
    2-students
    3-teacher-student

    The latter would contain a record for each teacher-student combination.

    Relation #1 above would consist of table 1 linked 1:N to table 2 which would link 1:1 to table 3;
    Relation #2 above would consist of table 3 linked 1:N to table 2 linked 1:1 to table 1.

    To me this looks similar to what you are suggesting except you are trying to get by with a single set whereas I would recommend two.

    Bill
    Bill Hanigsberg

    Comment


    • #3
      RE: Many to many links in a set, I think?

      Instead of a many to many link, I think I would make a one to one link. What I mean is a:

      header linked with personlist linked one to one with organization (even if the organization they represent is themselves)

      or you could link the header with an organization with a personlist (once again, the organization could be "Themself".)

      I guess it depends on who bears the most responsibility to return the tool, the person or the organization.

      Additionally, the organization could be a one to many set with a list of individuals, and calling in the organization could allow you to lookup a list of people related to that organization (and that organization only).

      Regards,

      Jay Talbott
      Jay Talbott
      Lexington, KY

      Comment


      • #4
        RE: Many to many links in a set, I think?

        Bill, you lost me:

        1-teachers
        2-students
        3-teacher-student

        Are you saying that table #3 consists of the student's name and the teacher's name? OR, doee #3 consist of the teacher_id & student_id? My understanding is that the latter is correct, resulting in two possible sets:

        Set No. 1
        Teachers[1:N]teacher-student[1:1]students

        Set No. 2
        students[1:N]teacher-student[1:1]Teachers

        Thus, allowing any number of teachers to be linked to any number of students (Set No. 1) and visa-versa (Set No. 2).

        - No?

        Peter
        Peter
        AlphaBase Solutions, LLC

        Peter@AlphaBaseSolutions.com
        https://www.alphabasesolutions.com


        Comment


        • #5
          RE: Many to many links in a set, I think?

          Brian
          You don't need a many to many link. I run a small equipment rental center with A5v4.5. All you need to do is to link your contract one to one with your customer table twice. Link contract to equipmentitem one to many and equipmentitem one to one to equipmentrate. This is demonstrated in the attachment. The rental form was made for a screen resolution of 1024X768 or higher.

          Comment


          • #6
            RE: Many to many links in a set, I think?

            Hi Peter,

            What you wrote is what I intended to say. Table #3 is just a linking table with identifiers for teacher and student although in practice it is sometimes nice to have a lastname field in there (calculated of course)so a person can make sense of the table in troubleshooting.

            Sorry for the ambiguity. By the time I wrote I had been grading exams all day and had few untainted neurons left at my disposal.

            Bill
            Bill Hanigsberg

            Comment


            • #7
              RE: Many to many links in a set, I think?

              Thanks to all of you for your help.

              I think now that the idea has sunk into my mind that I can do the application. It is just a big rethink from what I was doing before.
              Thanks to everybody, I might just need some more advise in the future: computors to me are like dentists; the only worse thing than going to a dentist, is not being able to get to a dentist.

              Brian.

              Comment


              • #8
                RE: Many to many links in a set, I think?

                Allen,

                Thanks for the help.
                I have tried that in the past and it worked fine in Alpha4 for us for many years. Now our old computor, or maybe itīs software, (or maybe itīs owner) is getting cranky. We are having corrupt files messages/failures. It is always the part of the application which has our most complicated set, it uses a file as parent with child set called 3 times, each of which calls the same child set possibly 3 times, lots of calculated fields, etc. Recently, I went thru and added all the calculated fields the make the "Euro" thing work with the same forms and layouts; that might have made the ultimate difference, but I am usually willing to blame things on the Euro!
                Reading thru the help from this message board, I think that I was doing something basically wrong in the way I made the application; althought it did work, it was from luck. I think now that our computor is getting more full, and the luck is running out; so we are having problems. Hopefully I can get our new application running ok before everything crashes around my ears. It is also true that nobody said in the instructions:- donīt have multiple child dbīs/sets using the same db.
                In comparison, fixing a hire machine is simple ! isīnt it?
                Our company is in Portugal, and very small. I reckon Alpha stopped us having to employ extra staff, so itīs paid for itself. May it continue to do so.

                Brian.

                Comment


                • #9
                  RE: Many to many links in a set, I think?

                  Bill,
                  Thanks for the help.
                  I will the making up our application along those ideas. I guess one thought which occurs is that the linking table is like gold, lose it for any reason and the whole lot goes. But I suppose that is true of most software.
                  Thanks again to all you guys who know these things. If I had realised this approx 1988, our company wld be much better off now.

                  Brian.

                  Comment

                  Working...
                  X