0 Replies Latest reply on Feb 17, 2016 3:14 PM by Okanagan.Mike

    How to use field from different table as drop down list?

    Okanagan.Mike

      Me again.

       

      I have two tables named Sessions and Presenters. I can fill out the required information for either a session or a particular presenter without a problem. I would like to show on the Sessions Layout who the presenter of that session is. Conversely, I would also like to show on the Presenters' layout what sessions they are presenting.

       

      The layout looks like this for Sessions:

       

      Screen Shot 2016-02-17 at 3.07.26 PM.png

      Right now nothing happens in the Presenter field. I have the following configuration for the Select Presenter field:

       

      Screen Shot 2016-02-17 at 3.09.33 PM.png

      I have a Cartesian relationship between the Presenters table and the Sessions table via an intermediate table called SessionsANDPresenters.

       

      Screen Shot 2016-02-17 at 3.12.07 PM.png

       

      What am I doing wrong? As always, your help is gratefully appreciated.

       

      Mike