1 Reply Latest reply on Apr 7, 2015 4:42 AM by philmodjunk

    Relationship

    garywatson

      Title

      Relationship

      Post

      I have a movie database. I have 3 tables named "Movies", "Actors" and "Characters". 

      What relationship do I need to create to be able to be on my "Actor" layout and be able to see in a portal the list of movies the actor is in and what their character name is for that movie.

      Let me know if you need more information, thanks

       

       

       

       

        • 1. Re: Relationship
          philmodjunk

          Start with these relationships:

          Actors-----<Characters>-----Movies

          Actors::__pkActorID = Characters::_fkActorID
          Movies::__pkMovieID = Characters::_fkMovieID

          You can place a portal to Characters on the Actors layout to list and select  Movies records for each given Actors record. Fields from Movies can be included in the Portal to show additional info about each selected Movies record and the _fkMovieID field can be set up with a value list for selecting Movies records by their ID field.

          For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained