Relationships

5,956 topics in this forum

1. Count of related records, sort of

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

2. Unmodifiable field

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

3. Base Table vs TO - foreign key

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

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

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

5. Venue clash checking based on multiple criteria

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

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

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

7. Simple value list question (I hope)

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

8. Portal displaying some but not all related records

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

9. Portal filtering includes empty values

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

10. Strange behavior (related calculations)

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

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

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

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

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

13. Help setting up tables and relationships based on XML

    By JMW, September 23, 2021   

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

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

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

15. 3 Levels Multi-Select Picker

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

16. Relationship and portal combination

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

17. TEXT CALCULATION FIELDS

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

18. RENUMBERING FIELDS IN JOINED TABLES

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

19. 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.1k views
    • 
    • MicheleC
    • August 17, 2021

20. Filter Relationship by type of child record?

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

21. Filtering via relationship and current date

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

22. m-to-n relationship via portal

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

23. Methods of Creating Records

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

24. Show certain related record

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

25. Relate 2 records???

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

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

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

27. Unique value within parent record

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

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

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

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

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

30. Constants in relationships

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

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

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

32. Self join set-up question

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

33. Show record only if ...

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

34. Multi relationship

    By Chrism, March 2, 2021
    • 0 replies
    • 465 views
    • 
    • Chrism
    • March 2, 2021

35. Importing records from a text file and matching (maybe) misspelled names?

    By AJ Venice, February 26, 2021
    • 0 replies
    • 528 views
    • 
    • AJ Venice
    • February 26, 2021