Finding & Searching

3,256 topics in this forum

1. Perform Find and Get(Last Error )

   By djc728, October 7
   • 4 replies
   • 364 views
   • 
   • djc728
   • October 8

2. Irritating hessitation

   By Søren Dyhr, October 8
   • 1 reply
   • 70 views
   • 
   • Søren Dyhr
   • October 8

3. Omit decimals in find request...

   By dhsa21, September 5
   • 7 replies
   • 286 views
   • 
   • comment
   • September 6

4. Constrain found set to unique values?

   By Toddbob, August 30
   • 6 replies
   • 209 views
   • 
   • comment
   • September 5

5. Restore found set after performing another Find

   By Rich S, December 4, 2023
   • 3 replies
   • 977 views
   • 
   • Søren Dyhr
   • May 3

6. Modify Last Find does not restore previous criteria

   By IlliaFM, May 2
   • 1 reply
   • 161 views
   • 
   • comment
   • May 3

7. Calc if a Record is in the Found Set, without running a loop

   By Slater, January 31
   • 6 replies
   • 823 views
   • 
   • Slater
   • February 1

8. Advanced sorting

   By VirtualBob, January 6
   • 0 replies
   • 426 views
   • 
   • VirtualBob
   • January 6

9. Position Function question

   By 2crabs, November 3, 2023
   • 0 replies
   • 373 views
   • 
   • 2crabs
   • November 3, 2023

10. quick find criteria starting with a number, like 1abc seem to return data with just "1"

    By Bob47, October 1, 2023
    • 2 replies
    • 411 views
    • 
    • Bob47
    • October 1, 2023

11. Find the value of the last record of one talbe from another table.

    By Tpaairman, September 6, 2023
    • 4 replies
    • 587 views
    • 
    • Tpaairman
    • September 7, 2023

12. Find and set script, I'm trying to find and send I have a global field(search) where I would like to search for an invoice number and send their information in the cash table[text]

    By zizou, June 5, 2023
    • 3 replies
    • 690 views
    • 
    • zizou
    • June 7, 2023

13. Searching upstream through a requirements tree

    By elipsett, March 25, 2023
    • 2 replies
    • 753 views
    • 
    • elipsett
    • March 26, 2023

14. Count Records Matching Two Fields

    By FlyersFn32, August 31, 2022
    • 4 replies
    • 1.3k views
    • 
    • comment
    • September 1, 2022

15. Find duplicates within found set

    By Oyseka, March 12, 2022
    • 11 replies
    • 1.4k views
    • 
    • bcooney
    • March 14, 2022

16. find in ()

    By jimlongo, February 12, 2022
    • 2 replies
    • 688 views
    • 
    • comment
    • February 12, 2022

17. Sorting Records after find is executed

    By Berkeleyblue, February 9, 2022
    • 5 replies
    • 836 views
    • 
    • rwoods
    • February 10, 2022

18. Find related (child) records from checkbox'd value list in parent

    By Rich S, January 19, 2022
    • 3 replies
    • 864 views
    • 
    • comment
    • January 19, 2022

19. Find Results for Calculated Field

    By derlandson, January 14, 2022
    • 4 replies
    • 540 views
    • 
    • derlandson
    • January 17, 2022

20. Quick find not working

    By infoweb, November 28, 2014
    • 18 replies
    • 10.5k views
    • 
    • [email protected]
    • December 25, 2021

21. Searching for selected checkboxes

    By Greg58, September 20, 2021
    • 2 replies
    • 584 views
    • 
    • LaRetta
    • September 20, 2021

22. Behaviour of the Quick Find feature in FM13

    By David Winter, August 22, 2021
    • 3 replies
    • 1.1k views
    • 
    • LaRetta
    • August 22, 2021

23. Bizarre Find Fail

    By Wickerman, August 10, 2021
    • 8 replies
    • 1.5k views
    • 
    • Wickerman
    • August 11, 2021

24. Multi criteria search???

    By Greg58, July 24, 2021
    • 2 replies
    • 1.1k views
    • 
    • Greg58
    • August 7, 2021

25. Finding a Specific Related Record

    By Rich M, July 27, 2021
    • 4 replies
    • 1.3k views
    • 
    • Rich M
    • July 27, 2021

26. Can anyone tell why this doesn't work?

    By willbilson, July 23, 2021
    • 5 replies
    • 696 views
    • 
    • comment
    • July 23, 2021

27. How can use the quick find field more than the purpose?

    By Msaeed, June 27, 2021
    • 2 replies
    • 566 views
    • 
    • Msaeed
    • June 27, 2021

28. Finds from Two Tables

    By Rich M, June 18, 2021
    • 9 replies
    • 934 views
    • 
    • Rich M
    • June 21, 2021

29. Find returns incorrect result set.

    By CCBtx, June 13, 2021
    • 8 replies
    • 673 views
    • 
    • CCBtx
    • June 13, 2021

30. Allow read-only users to select specific records from a found set

    By Dono K, April 27, 2021
    • 1 reply
    • 604 views
    • 
    • comment
    • April 27, 2021

31. Find by one or more ticked Checkbox'd values

    By Rich S, April 20, 2021
    • 6 replies
    • 1.3k views
    • 
    • Rich S
    • April 21, 2021

32. Searching for students by belt rank color

    By Jim65, April 16, 2021
    • 14 replies
    • 803 views
    • 
    • Jim65
    • April 17, 2021

33. [REQ] How to search for duplicate records to clear and only have unique ones in a table?

    By pixi, April 11, 2021   

    • duplicate records
    • unique records
    • 1 reply
    • 561 views
    • 
    • pixi
    • April 11, 2021

34. Find by another field containing year

    By Sinky, March 31, 2021   

    • find
    • date
    • (and 2 more)

       Tagged with:

      • find
      • date
      • year
      • set field
    • 7 replies
    • 731 views
    • 
    • Sinky
    • April 1, 2021

35. Find Record

    By milky, March 22, 2021
    • 10 replies
    • 1.7k views
    • 
    • comment
    • March 24, 2021