×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Find multiple records in a field

Find multiple records in a field

Find multiple records in a field

(OP)
I have an ID field and want to find all IDs that start with SMIT   JONE   WILS   and want to do it simultaneously.   How do I phrase that from within a "FIND"

RE: Find multiple records in a field

If your 'simultaneously' is within the found set, like:

Find all the records with 'SMIT', in this range find all the records with 'JONE' and in this found set find all the records with 'WILS', you need to constrain or narrow the found set.

1. Perform a find so that your database contains the found set for SMIT.
2. Switch back to Find mode and make the criteria to narrow the search to JONE and choose Requests menu > Constrain Found Set.
3. Switch back to Find mode and make the criteria to narrow the search to WILS and choose Requests menu > Constrain Found Set.

There you have the constrained found set.

If your 'simultaneously' is broadening the found set, like:

Find all the records with 'SMIT', all the records with 'JONE' and all the records with 'WILS', you need to extend the found set.

It's the same as above, just replace Requests menu > Constrain Found Set, by Requests menu > Extend Found Set.

RE: Find multiple records in a field

(OP)
It seems that if i had to find 10 specific names that I wanted for a report, it would take 10 separate find requests to do that.  Isn't there a way to do it with one find request.  When I was using Approach  i could    perform a find for many criteria in the same field separated by a comma.     for example: smit*,jone*,wils*  -   

RE: Find multiple records in a field

You can do this with the List() function or a valuelist based upon that field, to have a return separated list of unique values.

From there you can go with a global to find related records, to show in a list or in a portal.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close