Jump to content

Finding Records and saving to a found set


rfans
 Share

This topic is 7462 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

  • 2 weeks later...

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 & "

Link to comment
Share on other sites

This topic is 7462 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.