Using set with values from a table
The answer is clear too. You will need not a field, but another films_actors table. This table would act as your field, but much more reliable. This is called many-to-many relation.
I'm writing a database of all DVDs I have at home.
One of the fields, actors, I would like it to be a set of values from an other table, which is storing actors. So for every film I want to store a list of actors, all of which selected from a list of actors, taken from a different table.
Is it possible? How do I do this? It would be a set of foreign keys basically.
I'm using a MySQL database for a Django application (python), so any hint in SQL or Python would be much appreciated.
I hope the question is clear,
many thanks.