Relationship Diagram - Query
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'.