I have a DB that consists of Movie titles and the multiple dates ( as many as 10) on which they will be used in the coming year.
I built a flat table with 10 date fields.
Then tried to build a relational table with just movie title and dates linked to ID.
I cannot work out an ability to SEARCH...