This is a classic many to many relationship problem. A song can be in many books (with a different page number in each) and a book can contain many songs. You will need a "join" file in which a record is a book/song occurrence. This file would contain the page number for the occurrence of a song in a given book. This is much like the classic example of classes and students (a student can be in many classes and classses have many students). A portal in the Book database would display records with the Book Number of the current record from the "Join" file (not the Songs file), this way the page number would be for just the current book.

The table of contents would be printed from the join file using a subsummary by book sorted by book/page number.

-bd

This is probably a very simple question but my brain won't let me figure this out.

I have 2 files. One is songs. The other is the books (piano books) the songs are found in.

One song can be in many different books.

I want to have the song file show each book and the page number the song is found in. And I want the book to show a table of contents.

If I need more files that's fine. I'm just unsure where to begin.

This is all in FMPro 3

Thanks

Thank you!

Okay so I have to make a seperate file which lists all this information. I guess I was trying to figure out how to do it without making a new file. This is probably where I was running into the wall.

I've printed out the instructions and will hunker down in front of the computer tonight.

Thank you again!