I want to create a record in the actors DB when i input them in the movie DB. But only unique ones no dups.
Can anyone point me in a direction. Tried portal noes not work.
This is a classic many-to-many relationship ( 1 action can be in many movies, 1 movie has many actors) so you need a join table between the two tables. Call it "Credits" or "Appearances" or something that makes sense.
When you add an actor to a movie you add a join table record that links that actor to that movie.
Needs additional table 'role' where a record is created whenever an actor is part of a movie.
Do you really have two FMP files or are you referring to two tables.
If answer is tables, all you need to do is to make sure you have Movie::id_Movie_pk and in Actor::id_Actor_pk
Now create a new table named Cast with Cast::id_Movie_fk and Actor::id_Actor_fk
Create a new Relationship between Movie::id_Movie_pk = Cast::id_Movie_fk, check Allow creation of Records on Cast side
Now create a list of actors from Actors table where first field = Actor::id_Actor_pk and second field is NameFull
Use that List to automatically plug the Actor::id_Actor_pk into the Actor::id_Actor_fk.
In Movie Layout displaying Movie records, create a portal showing Cast relationship
Thanks what does fk and pk stand for
Foreign Key and Primary Key.
I recommend to study FTS (FileMaker Training Series) where FM 15 is still newest. FileMaker.com -> Shop ...
In order to match record from one table to another, we use id (keys) which are unique therefore Every record in Movie table will have a unique Primary Key, when creating a Cast record the Movie::id_Movie_pk will be "plugged" into the Cast::id_Movie_fk making the relationship One to Many (------<) meaning that for one movie you can have many actors.
At a minimum you would likely want to have a "join' table between movies and actors, because
a movie can have many actors
an actor can be in many movies
...so you need a join table to resolve the many to many.
...and sometimes an actor plays more than one role in a movie, for example Peter Sellers...
Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb (1964) - IMDb
...and yet likely gets paid only 1 salary for being in the movie
That last level of normalization might be more than you need.
Retrieving data ...