Search results

YAHOO!!!! That works. I was making the relationship in the wrong direction! My first day on the forum has been wonderful. You ROCK! and you are KIND TOO! Taking the time to really SHOW me how it could work was thoughtful . sli:rolleyes:

thanks for the quick reply I need to ponder how to do that. sli:D

Thanks Alex. I guess I did not create the relationships correctly. Main table AUTO ID 1 Shane Warner Bros 2. ET Luca Films 3. Help Viacom 4 Shaft Warner Bros AUTO ID movie air dates1 air date 2 air date 3 1 Shane...

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...