Well I only know basic SQL commands and creating a database.
But I’m wondering how would it be best to implemet a field to carry multiple entries pointing to another table.
An example is like the Actors field of a Movie database.
Each movie carries various different actors. If I want more info of the individual actor, I would pull the info from the Actor database.
Is it possible to put like multiple foreign keys into one field?
Any help would be appreciative.