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






      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

          Start with these relationships:


          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