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:
Right now nothing happens in the Presenter field. I have the following configuration for the Select Presenter field:
I have a Cartesian relationship between the Presenters table and the Sessions table via an intermediate table called SessionsANDPresenters.
What am I doing wrong? As always, your help is gratefully appreciated.