Jd Start simple:-
My suggestion is: Each movie must have its own unique code.
- Movie Title
- Any other movie information you want fields. and Multi field if you want
- DVD Number
Make a subsummary field based on sorting the DVD Number field. Place this field in the subsummary part.
When you sort on DVD Number you will get a list of all the movies on that disk,
If you sort Alphabetically on title you will get a straight list but you will need a title field
It is far to complex to do what you want with multi
Hi. Thanks for replying. As far as the tutorial you posted a link for is concerned...I doubt I'd ever understand it. I'm a low-level novice when it comes to databases. I'm highly computer-literate, but databases are unquestionably my Achilles Heel.
I've tried to understand relational databases, but I have yet to grasp the concept. Flat-file db's are easy. I can construct what I want in minutes.
I'm going to have to research what a subsummary field is, but the tutorial made my eyes glaze over.
Maybe I should just stick to a plain flat-file database for this?
The tutorial walks you through the process step by step. Instead of just trying to read and understand, try to do the steps and see if you can follow what happens and why. If you get stuck, feel free to post back here with questions. While the tutorial does work with related tables, the basic concept of a summary report with subsummary parts does not require related tables.
Chances are, though, that sooner or later you'll need related tables to do all you want to do with your information.