6 Replies Latest reply on Oct 9, 2012 12:59 PM by Dekade

    PhilModJunks' sample ManytoManyRelationshipDB

    Dekade

      Title

      PhilModJunks' sample ManytoManyRelationshipDB

      Post

           PhilModJunk:

           Regarding your https://www.dropbox.com/s/oyir7cs0yxmbn6i/ManyToManywDemoWExtras.fp7:

           Your sample file has tons of diversification possibilities to it. Especially when it comes to reporting and displaying found sets, etc. It's foundation is really going to make my home project fun.

           I am actually trying to step by step duplicate/alter your sample to accommodate my needs. I think I will learn more that way versus starting my own concept from scratch. As far as locating outside resources to further my re-acquaintance with Filemaker I did locate VTC on the web and have studied a lot of the ‘free’ lessons to get me back into the swing of some areas of Filemaker.

           You are such an advanced designer that it takes me quite awhile to decipher everything you have done even in your simplest of sample.

      Red typeset represents my personalizing.

           On the Basic Setup – am I correct in observing that the only way to get a ‘contact’ (Topic Name) into the Contacts (TOPICs) table is via the + script button? I think it is because I cannot at the moment see anything on the portal rows and there are already a couple of records in the Contacts (TOPICs) table. I also cannot see the drop box arrow for the Event_Contact (COMPOs_TOPICs) table ID field in layout or browse mode. I have checked and rechecked and feel confident that I have everything related properly and the proper value list structure for the ID field in the portal.

           Or – can I alternatively manually enter contacts in the Contacts (TOPICs) table and then see them in the portal as individual portal rows?

           I was just getting ready to alter the + button script to accommodate my needs and thought I would ask the above questions.

           Also, am I correct in observing that the Basic Setup layout Event_Contact (COMPOs_TOPICs) portal is required BEFORE the “EchbAllContacts” (CchbAllTopics) portal can function correctly/properly?

           Thanks,

           Dekade

           Filemaker Pro10 Advanced (wish I had FMP12ADV; but I don't)

           I've been 'playing around' in Filemaker since 2003. Retired now. I only get to work in it about 10 hours a week. Wish I could just spend all day in it. Too many honey do's! :)  To me it's fun and to many more others it's their lifeline (it used to be a small part of my lifeline from 2003 - 2010). Anyway you use it - it's a great program.

        • 1. Re: PhilModJunks' sample ManytoManyRelationshipDB
          davidanders

               These may be of interest, if you have not seen one of the many times I have posted them here (no provision for sticky read me first posts)

          http://www.filemaker.com/11help/html/create_db.8.2.html#1027557
          Home > Designing and creating databases > Creating a database > About planning a database
                              A well-designed database promotes consistent data entry and retrieval, and reduces the existence of duplicate data among the database tables. Relational database tables work together to ensure that the correct data is available when you need it. It’s a good idea to plan a database on paper first.                     
                                   Follow these general steps to plan a database:
          <SNIP>

          http://help.filemaker.com/app/answers/detail/a_id/3248/related/1
          Relational Database Design 101 (part 1 of 3): Designing a Flat File Database

          http://help.filemaker.com/app/answers/detail/a_id/3247/related/1
          Relational Database Design 101 (part 2 of 3)

          http://help.filemaker.com/app/answers/detail/a_id/3246/related/1
          Relational Database Design 101 (part 3 of 3)


          MY STANDARD LIST OF FILEMAKER LINKS

          The White Paper for FMP Novices is useful  - 
                                                            http://foundationdbs.com/downloads.html
                                                            
                                                            Filemaker Free - Listing of free resources  - 
                                                            http://filemakerfree.com/


          Free unlocked templates
                                                            By Richard Carlton Consulting
                                                            Starting Point -  Contacts | Accounts | Calendar | Estimates |Invoices | Projects |Products | Staff etc.
                                                            http://fmstartingpoint.com/
                                                            Donations -  Accounts | Contacts | Donations | Reporting | Prefs
                                                            http://filemakerdonations.com/
                                                            Recruiter -
                                                            http://rccrecruiter.com/alt-index.html/
                                                            Data4Life -  Contacts | Calendar | Projects | Prospects | Journal | Goals
                                                            http://data4life.net/

          RCC Blog  - 
                                                            http://filemakerbits.wordpress.com/
                                                            
                                                            By yzysoft.com  Contacts | Products | Invoices | Letters
                                                            Sample Database -
                                                            http://yzysoft.com/printouts/yzysoft_SampleDatabase.html

                                                            
                                                            A free calendar is available and can be integrated into your database
                                                            Seedcode Calendar Free -
                                                            http://seedcode.com/cp-app/prod/calendarfree10/
                                                            
                                                            Filemaker's  Online Help Pages
                                                            FMP 12  http://www.filemaker.com/12help/index.html
                                                            FMP 11  http://www.filemaker.com/11help/index.html
                                                            FMP 9    http://www.filemaker.com/9help/index.html


          Hints, Tips, and Demo Downloads  FMP version 6 thru 12
          http://www.databasepros.com/resources.html

          FMP business database demos - some are fully useable
                                                            The Excelisys Business Tracker V3.0  - 
                                                            http://excelisys.com/exbiztracker3.php/
                                                            
                                                            Filemaker released a FMP runtime database in 2007 for students called "Campus Productivity Kit" and is available online, notably at CNet
                                                            Google "Campus Productivity Kit"    https://www.google.com/search?q="Campus+Productivity+Kit"

          WIN -  http://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577579.html/
                                                            Machttp://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577567.html/

                                                            You can rename the database from a .usr file to a .fp7 file and open in FMP 7 thru 11

          Lynda dot com has Filemaker Videos (portions are free)
                                                            http://lynda.com/FileMaker-training-tutorials/116-0.html
                                                            
                                                            YouTube - Filemaker Videos

          FMTutorials Channel
                                                            http://www.youtube.com/user/FmTutorials/
                                                            
                                                            UK FileMaker Channel
                                                            http://youtube.com/user/UKFileMaker/
                                                            
                                                            FileMaker, Inc. Channel
                                                            http://youtube.com/user/filemakerinc/
                                                            
                                                            Lynda.com Channel - Filemaker videos
                                                            http://youtube.com/user/lyndapodcast/videos?query=filemaker
                                                            
                                                            Dwayn Wright's Channel
                                                            http://youtube.com/user/FileMakerThoughts/


                                                            Soliant Consulting Channel
          https://youtube.com/user/SoliantConsultingTV/

          Filemaker Academy Channel
                                                            https://youtube.com/user/filemakeracademy/
                                                            
                                                            Skeleton Key Channel
                                                            http://youtube.com/user/SkeletonKeySTL/


                                                            Accelerate Computer Training Channel
          http://youtube.com/user/AccelerateTraining/
                                                            
                                                            Filemaker News

          Scoop.it is an information curation site - free option available.
                                                            Filemaker Info  -  http://scoop.it/t/filemaker-info
                                                            Filemaker News  - http://www.scoop.it/t/fm-news

          Filemaker Wikipedia  - 
                                                            http://en.wikipedia.org/wiki/FileMaker
                                                            
                                                            Filemaker - Version By Version  - 
                                                            http://tokerud.com/filemaker/


          Search specific Filemaker sites with this Custom Google Search
          http://www.google.com/cse/home?cx=001044389222327874554:vi8it1bulm8
                                                             

                

          • 2. Re: PhilModJunks' sample ManytoManyRelationshipDB
            Dekade

                 David,

                 Thanks for the links. What are you meaning by "(no provision for sticky read me first posts)"?

            • 3. Re: PhilModJunks' sample ManytoManyRelationshipDB
              philmodjunk
                   

                        am I correct in observing that the only way to get a ‘contact’ (Topic Name) into the Contacts (TOPICs) table is via the + script button?

                   Not really. It's simply a very easy way to facilitate creating a new record on the "far side" of the join table. If your were to switch over to a layout based on contacts, create a new record and then returned to the basic layout, you'd find that the new contact has been added to the value list used for selecting a contact in the portal.

                   The Plus button just does that part via script and then goes ahead and creates a linking record in the Join table that links the current event record to that new contact record so that fields from Contacts are now accessible and editable in the portal row. There are notes on the layout that discuss more sophisticated options for adding a new contact.

                   

                        I think it is because I cannot at the moment see anything on the portal rows and there are already a couple of records in the Contacts (TOPICs) table.

                   The portal on this basic setup layout is based on the join table linking events and contacts. Until you create a record in this portal by selecting a contact from the drop down or by clicking the Plus button and then entering a name for the contact, there is nothing to see in this portal except the blank "add" row where you would add the first new portal row record.

                   

                        I also cannot see the drop box arrow for the Event_Contact (COMPOs_TOPICs) table ID field in layout or browse mode.

                   Is this in a new file or a copy of my demo that you have modified? The arrow is an option selected for the field in the Inspector on the Data tab and it will not be visible unless you also select at least the right hand border of the field to be visible on the inspector's appearance tab.

                   

                        Also, am I correct in observing that the Basic Setup layout Event_Contact (COMPOs_TOPICs) portal is required BEFORE the “EchbAllContacts” (CchbAllTopics) portal can function correctly/properly?

                   You now appear to be talking about the CheckBoxes layout. The Tables and table occurrences referenced on this layout are needed, but the portal to EchbAllContacts does not require any other portal to function correctly. I added a portal to an occurrence of Contact_Event on this layout simply so that you can see the data change when you click a check box in the other portal. If you remove the portal to EchBContact_Event from this layout, everything still works. The portal on Basic Setup or any other layout has no impact on the function of the check boxes portal.

                   PS. I suggest keeping an unchanged copy of the demo file for reference and then making and modifying as many copies of the file as you need to try things out. Try deleting the portal to EchBContact_Event from the check boxes layout of such a copy and see what happens!

              • 4. Re: PhilModJunks' sample ManytoManyRelationshipDB
                Dekade

                     Thanks PhilModJunk,

                     This is a NEW file I am creating and using your file as the guidelines. I have done files for my own use in that manner many times before. I seem to learn better that way. Plus, I don't really want to 'cop out' by simply making your layouts and tables (or other peoples layouts and tables) look different.

                     Just last night, however, I set up a laptop right next to my desktop and desktop monitor. I have your original demo installed on the laptop and I keep looking over at it as I work on my own version on the desktop. Much quicker than going back and forth between your demo and my work.

                     Yes, I always make copies of the original/demo files and never alter the original. Been in that practice since 2003.

                     

                          If your were to switch over to a layout based on contacts, create a new record and then returned to the basic layout, you'd find that the new contact has been added to the value list used for selecting a contact in the portal.

                     That's what I thought and that is exactly what I've done and that's what is confusing me. I will be implementing the button; but, I thought that I should be able to do manual entry into the TOPICs table and see them listed row by row in the portal. I was doing it that way just to make certain that my steps were being completed by me correctly.  I'll go in and add borders to the fields - maybe that is my problem. But, other than the borders, I'm 99% certain everything is set up correctly. If not the borders then I'll keep digging (which above - is the way I like to learn).

                     Like I told you before - I have some of my own ( minor elaborate) DB's from 2010 and they also incorporate adding records and then seeing them in the portal. That's why I'm a little puzzled at what I have evidently missed.

                     It's strange, once I retired I thought that I would never use the program again. Then I found a need to. Then I discovered I must have done a major mental block out of the days of stress at making a living. I am very amazed at all of the so to speak 'in the background' places (like generated value lists, etc.)  that I have to relearn to make certain that I'm going in the right direction. But what the heck - I'm getting it all back SLOWLY but surely.

                     I understand the reason for the occurrences but I just have to keep digging deep into them to make them work in my application.

                     I will study what you have just written to me, work it, and will be back with you if  needed. (more than likely I will be).

                     Thanks again,

                     Dekade

                • 5. Re: PhilModJunks' sample ManytoManyRelationshipDB
                  philmodjunk
                       

                            I thought that I should be able to do manual entry into the TOPICs table and see them listed row by row in the portal.

                       You need to take a closer look at the portal. It's not a portal to the Topic table, it's a portal to the Join table. Until a new record is also created in the join table that links to the new topic record, the new topic won't appear in the portal, nor should it appear as there is no way for FileMaker to know which records should link to the new topic and which should not.

                       Adding new record manually:

                       1) Go to the topics layout. Create a new record and fill in the fields.

                       2) Return to the original layout and select that new topic from the drop down so that you create a new join table record that links to the new Topic record.

                       Using the script.

                       Just click the button and fill in the new blank fields that automatically appear in the portal. The scritp does steps 1 and 2 for you, but without entering any information in the new topics record except for the auto-entered serial number. That's where the user has to step in and provide that additional information, either in the row of the portal--the way that the demo file is set up to do, or via other methods.

                  • 6. Re: PhilModJunks' sample ManytoManyRelationshipDB
                    Dekade

                         Gotcha. Yes - I do have it as a portal to the join table. I have always understood that fully. That was a given DB design that I never did forget.

                         I'll work on this in about 4 hours from now and I bet I'll get it correct.

                    In fact, I couldn't wait. Just went and added the borders, went back to the join table, down arrow now showing, clicked the ID field, selected a record, and everything is Kosher.

                    Now my next "non Filemaker" 4 hours will be much more pleasant and better focused on their calling!

                    Back at ya in the near or distant future.

                         Dekade