2 Replies Latest reply on Jan 9, 2009 12:42 PM by sannyasi

    Relationships in filemaker 9

    sannyasi

      Title

      Relationships in filemaker 9

      Post

      I am trying to build a relationship between two sets of data and can't get it to work.

      I have looked through the help files at various techniques but can't get anything to do what I need.

      I think the trick will be in the relationship graph.

       

      What I've done:

       

      I have two tables of info. One set is "Shots" and the other is "Assets"

      I have a field in "Assets" called "shotOwnership" and in a layout I have that field controlled via checkbox list based off a valuelist of every shots name(returning a list of every shot the asset lives in separated by carriage returns )

      This gives me an asset centric view with a list of shots.

      (ie. One asset and a list of shots to choose from)

       

      What I need:

       

      I want to keep this and add the option to switch to a shot centric view while maintaining the ability to select which assets belong to that shot.

      (ie. One shot and a list of assets to choose from) 

       

      These two list can not be independent from each other (a change in one happens in the other)

       

      So for example I should be able to do this.

       

      1. Go to asset centric view of asset "A"

       

      2. Select shots "1, 5, 20, etc...."    

       

      3. Go to the record of asset "B"

       

      4. Select shots "2, 4, 20, etc...."     (my setup is working up to this point)

       

      5. Then switch to the shot centric view of shot "1"

       

      6. I should see a list of all assets with asset "A" already checked

       

      7. Go to shot "2" and see asset "B" checked

       

      8. Go to shot "20" and see asset "A" & "B" checked

       

      9. In this view, check asset "C" as on

       

      10. Go back to asset view, record "C" and shot "20" should be checked on.

       

       

      Sorry if my explanation is long winded. I just wanted to be clear.

      Thanks in advance for any advice or direction/tutorials/links.

        • 1. Re: Relationships in filemaker 9
          swj
            

          sannyasi,

          Take a look at my copy of your file as Shots&Assets1

           

          Is this what you mean? You can make point 6 work just by adding a portal to your shot centric view. This will show the list of assets A, B etc.

           

          But, I think that the method you are using is OK to work in one direction only. If you wish to select records from either view, then you will need to create a many-to many relationship by adding a join table, as you can see in Shots&Assets2.

          • 2. Re: Relationships in filemaker 9
            sannyasi
              

            Thanks for the reply.

            Those setups are close to what I came up with minus the join table... still trying to wrap my brain around the relationship graph when it goes beyond simple matched fields.

             

            I've created a quick file to illustrate what would be an ideal setup as far as functionality. (pay no mind to the ui of course)

             

            myFile

             

            So this setup works for each side, but the records don't update each other.

            I'm sure I could write a script or layout to gather the information from one record and display it in another. But I would really like the functionality of entering data from either side of the relationship.

             

             

            Thanks again.