DVD Database Creation

[Torani]

Hello everyone,

I am rather new to this and am trying to create a simple database to track my DVD collection. I have seen many templates on the web but they are too elaborate for me. I dont care about including the actors and plots, just the title of the disk is all I want.

The trouble I am having is trying to decide how to structure the database. The information I am interested in is this:

Some movies have Sequels. Some Shows have Seasons with multiple disks (exa. Season 1 Disk 1). Very few of the shows have similar titles. I store my DVDs alphabetically by Title.



How can I structure my database so that it can track Sequels and Seasons, sorting the Report view with the Sequels and Season shows grouped and sequentially indexed together?

Thanks for your help

[orange]

See this
http://www.rogersaccesslibrary.com/T...lationship.zip

[Torani]

Orange,
Thank you for your quick reply. It's gonna take a little time for me to digest that link and see if I can apply it. I will respond later to say if it worked or not.

Thanks again,

Torani

[Torani]

Please mark this as SOLVED.
The link was very informative, but I managed to solve the problem by nesting the Group and Sort filters. It's not pretty, but it is working so far. This is what i've done in my Report Form:

Sort Title by first 12 characters
->Group Season (for annual tv series' seasons)
->Sort Season (arranges Seasons by a to z)
->Group Disk (for Seasons with multiple disks)
->Sort Disk (puts disk in order 1-X)
->Group Sequel (for Movies with Sequels)
->Sort Sequel (orders Sequels first to last)