I found the meaning of life - enquire within

Need help Database
1

Sorry, not really - just need some help with data linking.

Quite new to this malarkey. I’m trying to link two different datatypes with eachother so that the inputting of one data can effect both.

For example one datatype is Plays and the other Actors. I want to make it so that the inputting of the actors for a certain play then updates the actors datatype with the fact that they were in that play.

Kind of like how IMDB works. You enter a film and it’s actors and the actors pages are automatically updated with the fact that they did that film.

please help!

thanks so much.

2

Have a Play field on the Actor datatype (as a list).

Then, when you add an Actor to a particular Play, also just add that Play to the Actors Plays field.