LXR Posted April 27, 2005 Share Posted April 27, 2005 I want to create a script to Find Records based on criteria in 2 Repeating Fields. Each Repeating Field has 3 repetitions. Field 1 is a value list using peoples’ names (Bob, John, Bill). Field 2 is a value list relating to a project’s status (Open, Completed). I want to create a script to find all records that display “Bob’s†“Open†projects, and omits all of “Bob’s†“Completed†projects. For Example - Find records where - Field 1 Rep [1] = Bob and Field 2 Rep [1] = Open or Field 1 Rep [2] = Bob and Field 2 Rep [2] = Open or Field 1 Rep [3] = Bob and Field 2 Rep [3] = Open A record usually contains several combinations of persons and project status. For Example: Field 1 Rep [1] = Bob and Field 2 Rep [1] = Open Field 1 Rep [2] = John and Field 2 Rep [2] = Open Field 1 Rep [3] = Bill and Field 2 Rep [3] = Completed I have tried a number of Find/Omit combinations, but nothing returns the desired result. What am I missing? Link to comment Share on other sites More sharing options...
Robert Schaub Posted April 27, 2005 Share Posted April 27, 2005 When ever you do a find in a repeating field... no matter where the word in in the reps it will find it So if you are searching 2 fields at the same time try this in a script Enter Find Mode [ ] Go to Field [Field1] Pause script New record request Go to Field [Field2] Pause script Perform Find [ ] When the script pauses , you enter the find criteria, then press enter. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.