AnsweredAssumed Answered

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

Question asked by Okanagan.Mike on Feb 17, 2016

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.