Page 1 of 1

Find recods in database

PostPosted: Fri Jan 27, 2006 3:49 am
by Guest
Sorry my english but I go to try to place my problem.

I want find in database the records that i have in a dbf table. I only want to find the records. I do not want to modify the records in the database.

DBF table with 25 records (the number of records can change):
Field: 2; 5; 22; 30;......45

these fields exist in the database (with 500 records)

How can i make this? Can i make this using one script?

any suggestion is welcome

PostPosted: Fri Jan 27, 2006 5:44 am
by John Sindelar
< I"ve moved this from the Custom Functions Forum to this General Support Forum. Sorry for the inconvenience. >

I'm not quite sure what you're trying to say here: "Field: 2; 5; 22; 30;......45 " but I'd recommend looking in FileMaker's built in help, searching for "Find" and reading the section called "Finding Records."

Write back if that doesn't help.

PostPosted: Fri Jan 27, 2006 9:21 am
by Guest

PostPosted: Fri Jan 27, 2006 1:59 pm
by John Sindelar
Thanks. That helps a bit, though I'm still not sure why you need to introduce all the values... here are some thoughts:

Entering "*" into any field will find all records with any value in that field. (If the fields are numbers, you can also enter ">0" as your find request.

You can find ranges of numbers like "2...268".

Does that help?