Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

  • Newbies
Posted

I have a database that has a number field with numbers from 1 through 35. If I want to select the records with numbers 1, 5, 32, is there an easy way to do it....instead of multiple requests? Please help! Thanks....

Posted

I wonder what he means by multiple requests. He might mean, enter find mode, find the "1" records. Enter find mode again. Find "5" records. Enter find mode again. Find "32" records.

Dale, do you understand that you can create multple request before performing the find? Enter find mode, enter 1 in search field. New request; enter 5; new request; enter 32. Now perform find.

Also, you could use a global field, a checkbox and a relaltionship to show all the records in a portal.

Posted

I'm wondering if there isn't something else these records have in common that the find could be based on, that would return these records 1, 5, and 32?

Lee

  • 1 month later...
  • Newbies
Posted

This is a little late (only here when I need help), but...if you want to find those exact numbers all of the time, why not another field (calculated field--If(yourfield=1 or yourfield =5 or yourfield=32, "x", ""). Then you could find on the new field (find new field=x) or create a script that will do it.

Another way would be to make a "Dummy" find. Enter find mode (find 1), and without entering anything in any of the fields, control N for new request (find 2), control n for new request (find 3). Do this for as many finds as you'd like. Then create a script that would be to restore the find. When you perform the script you would be taken to find mode with three (or your number of finds) blank find request. You could then enter your numbers to find.

This topic is 7365 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
×
×
  • Create New...

Important Information

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