I have 2 Tables in my Access database.
Videos: 700 records Titles, categories, locations, etc.
Categories: 28 records
My plan is to physically store the DVDs by category in different places in my home.
I would like to create a program in Access to search for a DVD to watch.
My thought was to present a screen in MS Access where the user could first select a Category.
Then using that selected Category select a movie and Location from the available DVDs listed.
Finally, Print a report of all DVDs in that Category.
Suggestions?
Thanks, AZtecfan63