August 12, 200421 yr Newbies 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....
August 12, 200421 yr Not easy, no. Sorry. But the difficult way may be worth it for you. Why do you not want to enter multiple requests? Jerry
August 12, 200421 yr 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.
August 12, 200421 yr 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
September 24, 200421 yr Newbies 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.
Create an account or sign in to comment