1 Reply Latest reply on Oct 14, 2014 2:24 PM by philmodjunk

    I am trying to create a database with three product types. I was successful with one type, but the...

    fjron

      Post

      I am trying to create a database with three product types. I was successful with one type, but the other two give me an error. I am simply trying to create a one-to-many relationship between the product type and a stocking location. I keep getting a message about having to create an occurrence table. These is a join table. I can do one side or the other but not both except for the first table as you can see in the image. Any ideas why?

      Platt_College_Datavbase_relationship_issue.jpg

        • 1. Re: I am trying to create a database with three product types. I was successful with one type, but the...
          philmodjunk

          The message that pops up explains why you are getting this error. The path from one table occurrence to another in the relationship graph can never produce a situation where you see a "loop" or multiple paths that link the same two table occurrences.

          If you have these relationships: TableOccA-----TableOccB------TableOccC

          all is ok the "path" from A, to B to C is a single path. but if you have:

          TableOccA-----TableOccB
               |                         |
          TableOccD------TableOccC

          You have a problem. The path from A to C can be A to B to C or it can be A to D to C and FileMaker cannot allow that and still function.

          The solution is to add a new table occurrence with the same data source table as one of these existing table occurrences. Select TableOccD and then click the duplicate button (two green plus signs). This then would allow you to link records like this:

          TableOccD------TableOccA-----TableOccB-----TableOccD 2

          The table occurrence "boxes" named TableOccD and TableOccD 2 both refer to the same records in the same table. If you hover the mouse over the arrows in their upper left corners, you'll see the same data source table name pop up for both. This is what the error dialog that you show is offering to do for you.

          I recommend this tutorial on Table Occurrences, what they are and how to use them: Tutorial: What are Table Occurrences?