2 Replies Latest reply on Sep 6, 2016 12:03 AM by alangodfrey

    How to get info of a TO in a layout




      I am new to filemaker, so maybe this is a stupid question and I hope I put the question in the right location.  In the figure below I shows a simplified version of my database structure, to support my question. The actual database is already a big spider web with relations.

      The database consists of companies (red) and products(blue). And for both original tables I have a layout. Each product is made/developed by a certain company.





      On the layout of the companies I want to add a portal which lists the products used by that specific company using a joined table(green). In attempt to keep the relationship overview readable I used multiple table occurrences.

      Until here everything works fine: I have a nice list of used products on the Company layout.  But now I would like to display the inverse information on the product layout: a list of companies which are using it.

      As far I understand filemaker: layouts are based upon table occurrences, so with the current structure I can’t get the information of the joined table on a layout of products. Is this correct?

      To solve this I could delete the “product copy” TO and make a direct link to the product table, but I would like to avoid that. (keep the relation diagram readable). I don’t want to make my layout based on the “product copy” TO. ?(other not shown relations)

      So what is a good approach for this?

      Should I use a copy of the joined table? I this the way to do this? Or are you not supposed to make copies of the joined table. What is the good practice to do solve this issue.