9 Replies Latest reply on Jan 25, 2017 10:32 AM by philmodjunk

    <unrelated table> ???

    DonKlein_1

      I have duplicated an existing data base. I'm rearranging fields in the duplicated layout. All is well except two fields (text only) show <unrelated table> in the browse mode (not in the original database). There are no tables in this data base. I've played around with this field(s) for hours and cannot get rid of <unrelated table> What's going on? (I'm using FMP 12.

        • 1. Re: <unrelated table> ???
          SteveMartino

          Can you show a screenshot in Layout Mode, or attach a copy of the DB?

          Are these merge fields?

          Being you have both databases, what should the two fields have in them, and what do they look like in layout mode on the original database.

          When you click on the field in layout mode, both databases, does the inspector offer any insight.

          • 2. Re: <unrelated table> ???
            keywords

            "There are no tables in this data base". Correction. You have at least one table in the database; it contains your fields, and if the database is flat, as it sounds like it is, then it is the only table. However, there could possibly be more than one TO (Table Occurrence)—even a self-join relationship—which was set up properly in the original database and that you have failed to replicate correctly in the duplicate. Take a look at your Relationships Graph and see. And, as Steve has said, post some screenshots or even a clone of the file itself and it will be easier to assist you instead of having to guess at what your problem is.

            • 3. Re: <unrelated table> ???
              philmodjunk

              Enter layout mode and double click one of these field objects that come up as <unrelated table>. You'll find that you need to first select a different, related table occurrence and then a field for this field object as it currently refers to a table occurrence that is not related to your layout's table occurrence. (The layout's table occurrence is specified in layout setup in the "Show records from" drop down.)

               

              Note to FileMaker: <Unrelated Table> should really read <Unrelated table occurrence>

              • 4. Re: <unrelated table> ???
                keywords

                "Note to FileMaker: <Unrelated Table> should really read <Unrelated table occurrence>"

                 

                Total agreement here. FileMaker's dual use of "Table" is the source of much confusion.

                • 5. Re: <unrelated table> ???
                  DonKlein_1

                  Hi Steve,

                  Although I've been using FileMaker since the early 90s I am a real dunce

                  when it comes to anything more than the basics.

                  Here are 4 screen shots; layout mode and the short yellow fields in the

                  upper section of the record; 01&02 duplicate record; 03&04 the original.

                  Browser and Layout. They are not merge fields. One field has a

                  cross-reference text such as Klein 2003: A26.b.2 and the smaller field

                  (Cat. short for Catalog) has just one letter of text such as a B or D; just

                  letters of the alphabet. I looked at the inspector in both original and

                  duplicate and they both look identical. I appreciate any help.

                  Don

                  • 6. Re: <unrelated table> ???
                    philmodjunk

                    To repeat:

                     

                    double click one of these fields while in layout mode to open the Specify Field dialog.

                     

                    Now pull down the drop down of table occurrence names. This list will be organized into two groups: Related and Unrelated. The table occurrence specified for these two fields will be listed in the unrelated group.

                     

                    Now make a note of the table occurrence specified in the "Show Records From" drop down in Lsyout Set Up.

                     

                    Finally, open manage | database | Relationships and locate these two table occurrences (each box in the relationship graph is a "table occurrence".) You will find that the table occurrence in layout set up is not linked to the table occurrence selected for those two fields and thus you get this error.

                    • 7. Re: <unrelated table> ???
                      DonKlein_1

                      I neglected to add that I first duplicated the original file, then deleted

                      some fields,

                      and finally rearranged those left in the new layout that you see.

                      D.

                      • 8. Re: <unrelated table> ???
                        DonKlein_1

                        Thanks for the advice but my proficiency with FMP is so amateurish that I

                        cannot follow your instructions.

                        For the time being I am trying to work with another respondent to my

                        request.

                        Thanks!

                        Don

                        • 9. Re: <unrelated table> ???
                          philmodjunk

                          Fair enough, but my response was to the others responding to this thread as much as to you as there is a pretty simple way to show why you are getting this error message.