3 Replies Latest reply on Dec 1, 2011 11:39 AM by philmodjunk

    Relationship Diagram - Query



      Relationship Diagram - Query


      Dear All,

      Obviously I am new to FMP and trying to get my head into a database that I have inherited.

      I am slightly confused when looking at the relationship diagram.

      Not all the tables shown in the diagram appear in the Table list.

      I am assuming that these additional 'tables' are result tables which are combining data from various main tables.

      I would like to create some new relationships and put the results in one of these additional 'tables'

      I think that these additional tables may be appearing in the relationship diagram as a result of look ups. 

      If this is the case can you advise how these appear in the relationship tab and how I can create new occurances of such 'tables'.

      Many Thanks.