1 Reply Latest reply on Dec 14, 2011 9:25 AM by philmodjunk

    Related Tables



      Related Tables

      Your post



      I keep getting errors of unrelated tables.  I'm sure it is because of how I have set up the database I am using.  I have fields that come from tables not related to my other tables, but I'm not sure how to link the two.  

      Do I have to create all of the same field names in a linked table connected to my database?  Is there no way to link my entire table to another table even if the fields aren't the same?  

        • 1. Re: Related Tables

          The names of the fields have nothing to do with this. The table occurrences (boxes) in Manage | databae | relationships and how you have linked them in relationships are what you will need to examine to figure out what is going wrong for you.

          Each layout specifies a single table occurrence in Show Records From in Layout Setup. That's your starting point.  Each field and/or portal you add then requires you to first select a table occurrence (Filemaker labels the drop down as though this is a list of tables but the names listed are of the table occurrence boxes--not the actual tables) in a drop down, then you specify the fields taken from that table's table occurrence. Since it's possible to have more than one table occurrence for the same table, you might have added fields from an unrelated table occurrence and this will produce the error text you are seeing.

          To learn more about table occurrences and how they control the function of your databases, see here: Tutorial: What are Table Occurrences?