2 Replies Latest reply on Jun 7, 2013 11:07 AM by JimMac

    Creating a table with fields connected to multiple hierarchies...  Oh boy...  See post...

    DaveHardings

      Title

      Creating a table with fields connected to multiple hierarchies...  Oh boy...  See post...

      Post

           Hello and thanks for taking a look...

           I am creating an archaeological database that has a hierarchy ranging from Site all the way to Individual Objects.  The problem I am having, is getting the Individual Objects table to be "flexible" in displaying/ auto-filling information from one table or another dependant on it's specific attributes.

           So, at the top of the hierarchy, we have the Site table.  After this comes the Sub-site table (a specific region within the site).  Connected to this, are the Individual Object table and the Structure table.  The Structure table and the Individual Object table are linked together as well.  (I am skipping a few tables in between, but this example should suffice).

           It may be the case, that an individual object was found in a structure, however it may also be that case that it was found unassociated with a structure.

      So, when I am entering data into a record on the Individual Object table, I need to be able to enter the structure name into a field, which then auto-fills the Sub-Site, and Site field (since the structure is within a sub-site and the sub-site is within a site and these records already have data), but I also need the option to NOT enter a structure name, and enter the sub-site instead, which should then auto-fill the Site field.

           I hope that makes sense.  This is my first database and my terminology may not be so great...

           Any suggestions would be greatly appreciated!

        • 1. Re: Creating a table with fields connected to multiple hierarchies...  Oh boy...  See post...
          philmodjunk

               This isn't something where you can leave out details in how you have set up your relationships between tables and still get help on how to fix this. I suggest a detailed post--perhaps with a screen shot of manage | Database | Relationships where we can see and understand each table occurrence and match field involved.

               It will also help to know what version of FileMaker you are using. Execute SQL might be a major problem solver for what you need here, but only if you are using FileMaker 12.

          • 2. Re: Creating a table with fields connected to multiple hierarchies...  Oh boy...  See post...
            JimMac

                 Libraries have the same problems when assigning a new book to Library of Congress.  It is easier to assign Top/Down than Bottom/Up.

                 I would ask how you do it on PAPER?  FMP can be incoded to follow your paper steps.

                 I would think assigning a Table to each Layer of hierachies and each Table assigning its own Unique Serial Number would lead you to then bottom of the list [Objects]

                 Thus and object will have "Assignment" ID for each Layer...

                 So i would create an Object layer by top/down and then decide to NOT enter the structure Name after the creation of a new object layer Top/Down.

                 Jim...