Finding Records and saving to a found set

[rfans]

I am working on a title and copyright db and need a solution to a find problem I have encountered. The purpose of this db is to free the user from having to type out info to be used for paste-up in music publishing.

The user needs to find a series of different song titles and then save them to a found set to be formatted and printed. A multiple find request does not work since there are different songs with the same title in the db.

It would also be nice if the user did not have to type in the entire title when performing a find. Is there a way to perform a find using the first couple of words in a title, then selecting the correct title from the results of this find to be saved into a new found set?

[BobWeaver]

Yes, you can just type in a couple of words as long as you don't use the exact match option. As for the rest, you haven't really explained your search criteria. In order to set up a workable find request, you will have to ask yourself "What is the actual criteria that the record must meet in order to be in the found set?" If there are two records with the same song title, and one belongs in the found set, and the other doesn't, what is the other criteria that you are using to make the distinction?

Example 1, if you are looking for Stairway to Heaven by all artists excluding Led Zeppelin your search would be:

Request 1:

Title = "Stairway to Heaven"

Request 2:

Omit

Artist = "Led Zeppelin"

Example 2, if you are looking for "Stairway to Heaven" by Led Zeppelin only, your search would be:

Request 1:

Title = "Stairway to Heaven"

Artist = "Led Zeppelin"

Once you have a valid found set, you can use a separate field, SongSetID, to keep track of it. Use the Replace command to set it as follows:

SongSetID = SongSetID & "