Jump to content
Sign in to follow this  
rfans

Finding Records and saving to a found set

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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