Relationships

5,961 topics in this forum

1. Calculate the earliest date (field B) a number (field A) was exceeded

   By databaser, November 16, 2022
   • 1 reply
   • 1.4k views
   • 
   • comment
   • November 16, 2022

2. join table question - multiple users?

   By human, November 7, 2022
   • 13 replies
   • 1.2k views
   • 
   • comment
   • November 13, 2022

3. Is a portal empty

   By Raymack, November 1, 2022
   • 3 replies
   • 1.3k views
   • 
   • Raymack
   • November 1, 2022

4. Populating a Relational Database from available data files

   By Raymack, October 20, 2022
   • 8 replies
   • 1.1k views
   • 
   • Raymack
   • October 23, 2022

5. Reporting Subsummary results from a CheckBox Set

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

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

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

7. Count of related records, sort of

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

8. Unmodifiable field

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

9. Base Table vs TO - foreign key

   By centauri272, August 4, 2022
   • 9 replies
   • 1.1k views
   • 
   • centauri272
   • August 12, 2022

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

    By Slater, June 10, 2022
    • 5 replies
    • 1.1k views
    • 
    • Slater
    • June 13, 2022

11. Venue clash checking based on multiple criteria

    By Bullion, May 18, 2022
    • 4 replies
    • 1.1k views
    • 
    • comment
    • May 18, 2022

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

    By Bullion, May 3, 2022
    • 4 replies
    • 1.1k views
    • 
    • Bullion
    • May 3, 2022

13. Simple value list question (I hope)

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

14. Portal displaying some but not all related records

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

15. Portal filtering includes empty values

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

16. Strange behavior (related calculations)

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

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

    By tomislaw, February 20, 2022
    • 10 replies
    • 1.3k views
    • 
    • tomislaw
    • February 22, 2022

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

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

19. Help setting up tables and relationships based on XML

    By JMW, September 23, 2021
    • 23 replies
    • 2.7k views
    • 
    • JMW
    • December 14, 2021

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

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

21. 3 Levels Multi-Select Picker

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

22. Relationship and portal combination

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

23. TEXT CALCULATION FIELDS

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

24. RENUMBERING FIELDS IN JOINED TABLES

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

25. How to tell if table/data is unused

    By MicheleC, August 17, 2021
    • 2 replies
    • 1.3k views
    • 
    • MicheleC
    • August 17, 2021

26. Filter Relationship by type of child record?

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

27. Filtering via relationship and current date

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

28. m-to-n relationship via portal

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

29. Methods of Creating Records

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

30. Show certain related record

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

31. Relate 2 records???

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

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

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

33. Unique value within parent record

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

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

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

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

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