A many to many relationship requires a Join Table to manage the confusion.
If you have a Join Table between two many tables, sometimes you need another join table and a joining table for the join tables.
A screen capture of your Relationships in your Manage Database would be helpful.
How do you select an actor in your portal to the join table?
Do you use the Role::actorID field formatted as a drop down or pop up menu to select such? (my field name may differ from yours, but this field should be the field in Role not a field in Actors.)
I usually use a button placed outside the portal for adding new fields in the "far" table (actors in your case). It uses a script to create a new record in the far table and then a linking record in the join table. It might bring up a screen for filling in info on that new actor record or I might have sufficient fields from Actor in my portal row to fill in the information needed.
Thanks to both of you for taking the time to reply.
I had hoped that I could do this by selecting the actor_name field in actor, but it doesn't seem to work this way. Time for me to get back to studying the tutorial. I'll get back to this part of setting up my database after I know more, especially about scripts.
I had hoped that I could do this by selecting the actor_name field in actor
This is indeed possible. But this is not how it is set up in the training series lesson to which you have been referring.