Relationships

5,958 topics in this forum

1. Reporting Subsummary results from a CheckBox Set

   By Raymack, October 12, 2022
   • 8 replies
   • 1k views
   • 
   • Raymack
   • October 13, 2022

2. transfer a found set to a different already-existent window

   By Glenn S., June 24, 2018
   • 11 replies
   • 1.5k views
   • 
   • GFS
   • September 20, 2022

3. Count of related records, sort of

   By RSGC, August 27, 2022
   • 5 replies
   • 488 views
   • 
   • comment
   • August 28, 2022

4. Unmodifiable field

   By carlosnorvik, August 4, 2022
   • 2 replies
   • 586 views
   • 
   • comment
   • August 17, 2022

5. Base Table vs TO - foreign key

   By centauri272, August 4, 2022
   • 9 replies
   • 939 views
   • 
   • centauri272
   • August 12, 2022

6. Getting sort order of Portal as a number back to a different Table

   By Slater, June 10, 2022
   • 5 replies
   • 911 views
   • 
   • Slater
   • June 13, 2022

7. Venue clash checking based on multiple criteria

   By Bullion, May 18, 2022
   • 4 replies
   • 858 views
   • 
   • comment
   • May 18, 2022

8. Conditional Value List works in one DB but not another?

   By Bullion, May 3, 2022
   • 4 replies
   • 857 views
   • 
   • Bullion
   • May 3, 2022

9. Simple value list question (I hope)

   By muzz, March 27, 2022
   • 3 replies
   • 766 views
   • 
   • muzz
   • April 4, 2022

10. Portal displaying some but not all related records

    By relatively, April 3, 2022
    • 3 replies
    • 748 views
    • 
    • comment
    • April 4, 2022

11. Portal filtering includes empty values

    By muzz, March 20, 2022
    • 6 replies
    • 1.2k views
    • 
    • muzz
    • March 25, 2022

12. Strange behavior (related calculations)

    By tomislaw, March 15, 2022
    • 0 replies
    • 749 views
    • 
    • tomislaw
    • March 15, 2022

13. The portal show the "wrong" data, what I am missing?

    By tomislaw, February 20, 2022
    • 10 replies
    • 994 views
    • 
    • tomislaw
    • February 22, 2022

14. Creating a table to show multiple records of another table in one row

    By wattmhite, January 5, 2022
    • 1 reply
    • 589 views
    • 
    • comment
    • January 5, 2022

15. Help setting up tables and relationships based on XML

    By JMW, September 23, 2021   

    • relationships
    • 23 replies
    • 2.3k views
    • 
    • JMW
    • December 14, 2021

16. Creating a Value List in FMP 12 that is limited by the value in a field

    By gfr92y, November 8, 2021
    • 3 replies
    • 564 views
    • 
    • gfr92y
    • November 8, 2021

17. 3 Levels Multi-Select Picker

    By Amanco, August 5, 2021
    • 10 replies
    • 1.7k views
    • 
    • Amanco
    • September 7, 2021

18. Relationship and portal combination

    By sal88, August 25, 2021
    • 10 replies
    • 1.2k views
    • 
    • sal88
    • September 7, 2021

19. TEXT CALCULATION FIELDS

    By Simon Hall, August 24, 2021
    • 4 replies
    • 1.4k views
    • 
    • Simon Hall
    • August 25, 2021

20. RENUMBERING FIELDS IN JOINED TABLES

    By Simon Hall, August 24, 2021
    • 4 replies
    • 1.5k views
    • 
    • Simon Hall
    • August 24, 2021

21. How to tell if table/data is unused

    By MicheleC, August 17, 2021   

    • tables
    • table usage
    • (and 1 more)

       Tagged with:

      • tables
      • table usage
      • database cleanup
    • 2 replies
    • 1.2k views
    • 
    • MicheleC
    • August 17, 2021

22. Filter Relationship by type of child record?

    By Steve Martino, August 17, 2021
    • 2 replies
    • 776 views
    • 
    • Steve Martino
    • August 17, 2021

23. Filtering via relationship and current date

    By madman411, August 17, 2021
    • 2 replies
    • 781 views
    • 
    • madman411
    • August 17, 2021

24. m-to-n relationship via portal

    By MaxB, August 1, 2021
    • 8 replies
    • 1.2k views
    • 
    • bcooney
    • August 2, 2021

25. Methods of Creating Records

    By Amanco, July 22, 2021
    • 2 replies
    • 1.1k views
    • 
    • comment
    • July 23, 2021

26. Show certain related record

    By madman411, July 20, 2021
    • 2 replies
    • 587 views
    • 
    • madman411
    • July 22, 2021

27. Relate 2 records???

    By Greg58, June 29, 2021
    • 2 replies
    • 602 views
    • 
    • Greg58
    • June 30, 2021

28. Portals to display running player point totals for different people? Help (brain dead tonight)

    By Tony Martin, June 22, 2021
    • 1 reply
    • 624 views
    • 
    • comment
    • June 22, 2021

29. Unique value within parent record

    By madman411, May 17, 2021
    • 2 replies
    • 795 views
    • 
    • madman411
    • May 17, 2021

30. Relationship graph - can't work it out.

    By Greg58, May 11, 2021
    • 5 replies
    • 686 views
    • 
    • comment
    • May 12, 2021

31. Why can't I sort a table by a related field?

    By naio, April 24, 2021
    • 3 replies
    • 748 views
    • 
    • naio
    • May 7, 2021

32. Constants in relationships

    By passando, May 1, 2021
    • 2 replies
    • 640 views
    • 
    • comment
    • May 1, 2021

33. Go To Related Record, going to the wrong Table! (ie wrong direction)

    By Slater, March 22, 2021
    • 2 replies
    • 526 views
    • 
    • Slater
    • March 22, 2021

34. Self join set-up question

    By Hurlz, March 16, 2021
    • 2 replies
    • 494 views
    • 
    • Hurlz
    • March 17, 2021

35. Show record only if ...

    By Martin_01, March 11, 2021
    • 1 reply
    • 679 views
    • 
    • comment
    • March 11, 2021