The portal contains the PK of the players table as a drop down
And that would appear to be the problem. You need a portal to TeamPlayer with the _fk_Player field set up as your drop down--not a portal to Players and not the PK field. You can add fields from Players to the portal row and they will display player info when you select a player from the drop down.
Here's a demo file on many to many relationships that may help: https://www.dropbox.com/s/oyir7cs0yxmbn6i/ManyToManywDemoWExtras.fp7
That was it....darn...wish I would have posted a week ago. Thanks very much for your assistance. I vaguely remember a video training on this now. All my best and thank god for these forums
Well...I guess I'm still missing a piece...I had sample data in there and it appeared to work fine. I deleted all my players and teams and started from scratch. when I add a player or add a team I do not get any entries in the join table. I guess I was hoping this would happen automatically but it does not appear to be the case. do have the "create records through this relationship" ticked in both joins but I must be missing something else. Does record creation in the join table happen automatically or must I set something up for this to happen and if so what am I missing? I tried to follow your example but I'm not sure I fully understand it
It cannot happen automatically as the computer cannot read your mind to know how to link up your players and teams. "Allow creation..." is needed if you plan to use the portal to create new join table records, but it will not automatically update both match fields to link a player to a team. It allows you to go to a blank row on the player layout and if you then select a team in the FK field, a new record is created that automatically enters the player ID, but you had to select the team.
You may find this many to many demo file helpful: https://www.dropbox.com/s/oyir7cs0yxmbn6i/ManyToManywDemoWExtras.fp7