×
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

Peform Find Script Step

Peform Find Script Step

Peform Find Script Step

(OP)
I am having trouble writing a script which is supposed to look through all the records in the database then enter a find mode layout i have made, then perform a find on the records that fit the criteria.

Basically what i have is a field that asks if the user would like to select a record for editing.  Then i would like file maker to perform a find with the criteria for the field select record for editing with the value of "yes".

I have one method which just checks all the records and omits the records that have a "yes" value for the field select record for editing and then i just show the omitted records
which works,however there is a flaw to that algorithm
if they were to accidently press the button that is linked to the script after it has omitted the records wanting to be edited. then file maker will show the records that were not selected for editing and leave out the ones there were selected for editing.

Im sure the method of going into find mode and using the perform find scipt with a criteria is the correct way of doing it, however the script i wrote for this method is not working properly.

I currently have this for the script:

Go To find mode layout
Perform Find[restore]


and for the specify on the perform find

the action i have is Find
Criteria is supposed to search the Field
 Select Record For Editing: [YES]

with a value of yes.

from here i want those with a "yes" in that field to be isolated from the other records

RE: Peform Find Script Step

(OP)
never mind i guess in the criteria you have to put the quotation marks as well.

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